...

View Full Version : change date format using SQL - urgent



therry
08-19-2002, 11:23 AM
Hi,

I'm having a field which data type is datetime (ex. 2002-07-18 10:06:58.373 format). If I want to do a SELECT statement to display this field as 2002-07-18 format only without the time, how can I do that using SQL statement?

Thanks

Spookster
08-19-2002, 03:12 PM
http://www.mysql.com/doc/en/DATETIME.html



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum