System date..

Wrox Programmer Forums

		Wrox Programmer Forums > PHP/MySQL > MySQL
System date..

MySQL General discussion about the MySQL database.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

August 11th, 2003, 11:28 PM

arshad mahmood arshad mahmood is offline

arshad mahmood is offline

Authorized User

Join Date: Jun 2003

Posts: 32

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via AIM to arshad mahmood

Default

System date..

Hello Sir
In SQL server How can reterive the current date
by query.Is it possiable?
I hope u will guide me.
Thanks

arshad mahmood

__________________
arshad mahmood

Old

August 11th, 2003, 11:55 PM

happygv

happygv is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 2,480

Thanks: 0

Thanked 1 Time in 1 Post

Default

Use the following

Select getdate()

Getdate function returns the system date.

Regards,
Vijay G

Old

August 12th, 2003, 09:53 PM

arshad mahmood arshad mahmood is offline

arshad mahmood is offline

Authorized User

Join Date: Jun 2003

Posts: 32

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via AIM to arshad mahmood

Default

Thanks for help sir.

arshad mahmood

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert System date and System Time -Form _TextBox	cnkumar74	VB How-To	14	February 14th, 2007 10:52 AM
HOW CAN SYSTEM DATE N TIME BE CAPTURED IN A TXTBOX	cnkumar74	VB Databases Basics	6	February 14th, 2007 02:09 AM
System Date	adyaky	SQL Server 2000	2	January 6th, 2006 06:46 PM
How to get system login and date	Abhinav_jain_mca	General .NET	2	August 26th, 2004 01:12 AM
insert system date. no date and time	jimmy	Access VBA	6	November 20th, 2003 01:11 PM