George, The ODBC date syntax is best used for to make input format unambiguous, e.g.:
select * from orders where order_date = { d '2002-01-01'} This will allow you to select from a table regardless of the date format. For converting a date from one format to another, select it from a table and then use the PHP date() function to convert, e.g.: while (list ($timestamp) = each ($result_array)) { $new_format = date(Y-m-d, $timestamp); echo "$new_format<br>"; } Best regards, Andrew Hill 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 > 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 my_table????? > > -- > > > Best regards, > George Nicolae > IT Manager > ___________________ > X-Playin - Professional Web Design > www.x-playin.f2s.com > > > > > > Or you can format it with odbc date syntax in your query { d > 'YYYY-MM-DD' } > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]