Mssql/PHP4 - date fields not formatted correctly

Anon

This is my first jaunt into using MSSQL with PHP4. I've done quite a bit with PHP and Mysql but this project requires MSSQL. I got it up and working but I cannot pull datetime fields correctly but I can pull all other types ok.

Example: Field name ScheduleDate has a value of 5/22/00 in the database. When I read via PHP, it displays May 22 2.
When a field named ScheduledTime has a time value like 10:30:00 AM,
I get back is Dec 30 1 no matter what the time is.

This is a show stopper if I can't figure this out.

Thanks
Chris

Anon

Can you give us some code on how are you pulling the data ?

Anon

I got it figured out. You have to use a covert function while pulling the date and time info out in the select statement. Below is what I used:

$db = mssql_connect($hostname,$username,$password);
mssql_select_db($dbname);

$sql_query = "select
convert(char,ScheduleStartTime, 8)as ScheduleStartTime,
convert(char,ScheduleEndTime, 8)as ScheduleEndTime,
ConferenceNumber,
convert(char,ScheduleDate, 101)as ScheduleDate,
CustomerId,
Resource,
DestinationNumber

from $tablename

order by ConferenceNumber";

I wasn't familiar with having to do this since its not necessary in Mysql.

Thanks

Anon

There is another good discussion along with solutions. It solved all my problems when I ran into this problem.

http://www.phpbuilder.com/forum/read.php3?num=2&id=100916&loc=0&thread=100916