George,
You can use the date() function in PHP to change the format:
http://www.php.net/manual/en/function.date.php
Or you can format it with odbc date syntax in your query { d '-MM-DD' }
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software
i did it with date(F j, Y,strtotime(odbc_result($cur,date))).
but i very curios about the query. it must looke like..?
select date from my_table?
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
Or you can format it
://www.openlinksw.com
Universal Data Access Data Integration Technology Providers
-Original Message-
From: George Nicolae [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 12:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
i did it with date(F j, Y,strtotime(odbc_result($cur,date
-
From: George Nicolae [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 12:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
i did it with date(F j, Y,strtotime(odbc_result($cur,date))).
but i very curios about the query. it must looke like..?
select date from
George,
Yes, using the date() example.
Cheers,
Andrew
-Original Message-
From: George Nicolae [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 31, 2001 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
it is right but I want to select all data from a mdbdatabase
001 1:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] odbc date
it is right but I want to select all data from a mdbdatabase table and I
receive in '/mm/dd hh:mm:ss' format.
I told you I resolve this problem with date(F j,
Y,strtotime(odbc_result($cur,date))).
I what to know
If everything else fails, you can retrieve unix_timestamp(date) and use PHP's
date() to format the output.
HTH
Bogdan
George Nicolae wrote:
for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field,
php will automatically convert it to '/mm/dd hh:mm:ss' format regardless
