problem retrieve date format

[Anon]

i have a date stored in mssql7.0 db in
yyyy-mm-dd hh:mi:ss format. date column
data type is datatime.

when i tried to retrieve date value from db to php variable, date format automatically gets converted to month dd yyyy hh:miAM/PM

(Jul 29 2001 12:41PM)format.

how do i get the same date format which is stored in db ?

Thanks in advance
Jagan.

[cordex]

One solution
use mktime() to help you convert from a given date string to a UNIX timestamp.
use date() to convert that timestamp to any type of string pattern you like.

[alastair]

I store dates formatted in the way you suggest by PHP in CHAR fields (without the -: delimiters).

You can do easily do date comparisons in this format and you avoid the problem of the database thinking it knows best

[alastair]

Providing dates don't go back before 1970