Time convert problem

[Ralf Meuser]

Hi there,

I get form a database time with the format : 'Jan 01 1900
06:00PM'

I want to convert it to :HH:MM
I tryed it with $heure=(date("H:i",strtotime($row[0]))
but I get allways 20:55. even when time changes. Whats wrong ?

Does anybody know where I can get a good function which will convert date to
date and time to time with different formats ?

Thanks in advance for any help

Best regards

Ralf

[Alistair Baillie SS2002]

its because its not a php timestamp.

A quick search of google, revealed this;

http://php.codenewbie.com/articles/p...mp-Page_1.html

- Ali

"Ralf Meuser" <rm*****@free.fr> wrote in message
news:42***********************@news.free.fr...

Hi there,

I get form a database time with the format : 'Jan 01 1900
06:00PM'

I want to convert it to :HH:MM
I tryed it with $heure=(date("H:i",strtotime($row[0]))
but I get allways 20:55. even when time changes. Whats wrong ?

Does anybody know where I can get a good function which will convert date
to date and time to time with different formats ?

Thanks in advance for any help

Best regards

Ralf

[Colin McKinnon]

Ralf Meuser wrote:

Hi there,

I get form a database time with the format : 'Jan 01 1900
06:00PM'

I want to convert it to :HH:MM
I tryed it with $heure=(date("H:i",strtotime($row[0]))
but I get allways 20:55. even when time changes. Whats wrong ?

Does anybody know where I can get a good function which will convert date
to date and time to time with different formats ?

No, but wouldn't a simple substr(...) + check for AM/PM suffice?

C.

[NC]

Ralf Meuser wrote:

I get form a database time with the format : 'Jan 01 1900 06:00PM'
What type is the database field? DATETIME?
I want to convert it to :HH:MM
I tryed it with $heure=(date("H:i",strtotime($row[0]))
but I get allways 20:55. even when time changes. Whats wrong ?
Since strtotime() returns and unsigned Unix timestamp, it can only
work with dates after the Unix epoch (January 1, 1970).
Does anybody know where I can get a good function which will convert
date to date and time to time with different formats ?

You can format time on the database server:

SELECT DATE_FORMAT(your_time_field, '%H:%i') as formatted_time
FROM your_table;

Cheers,
NC