Time and Date messed up from odbc and php

[freebsd_dude]

Hello all,

I have this problem with time and date formating. I am using microsoft 2000 server running IIS 5.0 and php 4.3.0 with a odbc connection to a access database. Everything works fine but the time and date formating.

Example: In the msaccess 2000 database you will see the following data and time in msaccess: 4/4/2003 4:27 PM. When i select the odbc database php returns 2003-4-4 4:27:00 time is the same.

Does anyone have a idea what to do?

Thank you all,

[barand]

just reformat it using [man]date[/man] function.

eg $thedate = date('m/d/Y h:i A', strtotime(datefield));

hth

[freebsd_dude]

How would you format this in php to take out the time from the database to show the right time?

Thank you for all your help 🙂

freebsd_dude

[barand]

Leave out the m,d,y bits and you just get the time.

See [man]date[/man]

[freebsd_dude]

Thank you this worked 🙂