[Resolved] getting one digit hour for 0-12

[mrbaseball34]

I need to get my times formatted with one digit for the hour even though it may actuall have a 19:30 value.

How would I modify this to get that:

select
g.gamenum,
DATE_FORMAT(g.gamedate, '%a %b %e %k:%i ),

t1.teamname as home,
t2.teamname as visitor
from
games g
join
teams t1 on t1.id = g.homeid
join
teams t2 on t2.id = g.visitorid
where
g.gamenum = 238

returns:

238 Wed Jun 19 19:30 Orioles Cubs

I need:
238 Wed Jun 19 7:30 Orioles Cubs

Tried %h, %H and %I but still not correct formatting.

[Tracer]

What Database? MySQL?

I think it's either %h or %I

Check out the manual

Date Functions

[nemonoman]

DATE_FORMAT(time, '%k') -> 0...23
DATE_FORMAT(time, '%l') -> 0...12

that second is a lowercase L

[mrbaseball34]

Right in front of my stinking face...
Dog gone it. Wasted more precious resources...

Thanks guys...