[mythtv] Re:[PATCH] Mythweb: Fixes printing of time between noon and 1:pm

[Andy Davidoff]

If you use the database to retrieve or reformat time appropriately, you can
solve the locale/consistency issues.  Note also that a patch is forthcoming
to replace timestamps with date/time/datetime columns, so it's unwise to
depend on the raw storage format in the database.  Use SQL's strftime
analogs to retrieve the data in exactly the format you need and you'll be
immune to the low-level storage issues.


#if Geoffrey Hausheer /* Mar 29, 14:25 */
> Actually, I thought about his some more, and I don't think using strftime
> is a good idea.  Because of how myth stores time, it is sometimes needed
> to have a time without a date (i.e. for timeslot recording), which isn't
> really compatible with using strftime.  I would propose instead to
> consistantly use myth's yyyymmddHHMMSS format within mythweb, and have
> routines that can pullout the date, time or both (this is sort of how it
> is done today, but not very consistantly).
#endif /* ou401cru02 at sneakemail.com */