[Catalyst] SQLite Dates

[Kevin White]

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?

Thanks for any help

Kevin