Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [TheStone] extracting parts of datetime field

Quote Reply
Re: [TheStone] extracting parts of datetime field In reply to
Something is amiss with your global/template suggestion and that as from the format_date operation even before the conditional testing.

My field contains 2003-06-19 00:00:00
If I apply the line <%set time_formated = format_date($Launched, '%hh%:%MM%:%ss%')%>
and print out the value <%time_formated%> I obtain 07:33:33 (time somewhere I presume!)
Same thing for the month_formated which gives me 12 instead of 6.
I have tried reverting the field to a straight date field. No difference.
More time ;) on this one please!
Charly
Subject Author Views Date
Thread extracting parts of datetime field charly 4432 Jun 17, 2003, 3:20 AM
Thread Re: [charly] extracting parts of datetime field
604 4307 Jun 17, 2003, 10:41 AM
Thread Re: [TheStone] extracting parts of datetime field
charly 4285 Jun 19, 2003, 7:55 AM
Thread Re: [charly] extracting parts of datetime field
604 4279 Jun 19, 2003, 9:54 AM
Post Re: [TheStone] extracting parts of datetime field
charly 4272 Jun 19, 2003, 12:42 PM