[Catalyst] SQLite Dates

[Krzysztof Krzyżaniak]

Kevin White <kevin at theconfused.co.uk> writes:

> Hi folks,
>
> I am using SQLite for a quick app and within the app are some dates  
> that I am presenting in dd-MMM-YYYY. Trouble is SQLite requires them  
> in YYYY-MM-DD HH::MM::SS for it to do anything useful with. How would  
> I go about converting the incoming dates to the correct DB format and  
> vice versa? Anyone got any examples or could point me to one?

Not For This List But:

http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions

If You mean MMM as JAN, FEB etc. it's not possible AFAIR use this on
database level.

  eloy
-- 
-------e-l-o-y----------------------------e-l-o-y- at -k-o-f-e-i-n-a-.-n-e-t------

       jak to dobrze, że są oceany - bez nich byłoby jeszcze smutniej