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 regardles
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 http://www.openlinksw.co
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 forma
nLink Software http://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
>
Director of Technology Evangelism
> OpenLink Software http://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
&g
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 t
riginal 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 table an