prichardson Posted June 6, 2007 Share Posted June 6, 2007 In a sql statement how can I state the Day/Month/Year?I have: Date => 2007I would like it to say Date => 2007-01-01 Link to comment Share on other sites More sharing options...
aspnetguy Posted June 6, 2007 Share Posted June 6, 2007 use date_formathttp://dev.mysql.com/doc/refman/5.0/en/dat...ion_date-format Link to comment Share on other sites More sharing options...
prichardson Posted June 7, 2007 Author Share Posted June 7, 2007 I use asp and sql . That link was really good but for php/mysql - is there one for asp/sql?The format would be year/month/day or could be day/month/year - it does not really matter - as long as it shows the full date.Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.