[sqlite] How to handle single digit date ?

[w wg]

Hi,

This works as what I want :

select date('2006-12-05')
2006-12-05

But,
select date('2006-12-5')
null

Please help me , how to handle the single digit month or day ?

Thank you.
--
wwg

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------