strange behaviour of date_format? (mysql)

[xblue]

slightly puzzled...
I always thought 2004-01-28 00:00:00 would be a valid date, one second later than 2004-01-27 23:59:59.

But

SELECT DATE_FORMAT('2004-01-28 00:00:00', '%h:%i:%s' ) 

returns 12:00:00

Am I overlooking something?

SELECT DATE_FORMAT('2004-01-28, '%h:%i:%s' ) 

returns 12:00:00 as well, which I can understand in some respect, like "if no time is set, default to midday". But for a valid time as above?

[Norman_Graham]

Hi Xblue

%h is only for the 12-hour clock. You want %H.

HTH

Norm

[xblue]

shame on me :eek:
thanks, Norman

[Norman_Graham]

No worries, Xblue. Very glad to be of service.

Norm