date() use a timestamp. I receive a string. if I echo odbc_result($cursor,"date") it shows like "2001-11-21 00:00". Can it echo (without date() function because I don't receive a timestamp) "21 Nov 2001"?
-- Best regards, George Nicolae IT Manager ___________________ X-Playin - Professional Web Design www.x-playin.f2s.com "Andrew Hill" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 table and I > > receive in 'yyyy/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 I can receive a specific format from query "select date > > from my_table" > > > > -- > > > > > > Best regards, > > George Nicolae > > IT Manager > > ___________________ > > X-Playin - Professional Web Design > > www.x-playin.f2s.com > > > > > > > > "Andrew Hill" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > 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] > > > > > > > > -- 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]