hello sir, I tried this example
but getting error SELECT * FROM pet WHERE parsedatetime(birth, 'dd/mm/yyyy') Error parsing "2012-02-21"; SQL statement: SELECT * FROM pet WHERE parsedatetime(birth, 'dd/mm/yyyy') [90014-169]<https://192.168.123.109:8082/query.do?jsessionid=6a67a5a2b8f33c70a0073e255b4ff732#>90014/90014 (Help) <http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90014> how to parse please help me Thanks in advance On Mon, Oct 22, 2012 at 2:29 PM, priyanka <[email protected]> wrote: > hello sir, > > h2 date format is this DATE '2004-12-31' > > how to parse in dd/mm/yyyy > Iam getting this exception > > Cannot parse "DATE" constant "21/01/2012"; SQL > statement:<https://192.168.123.109:8082/query.do?jsessionid=6a67a5a2b8f33c70a0073e255b4ff732#> > > I saw the document but unable to understand how to parse > > can you give an example please... > > thank u.... > > On Thursday, March 20, 2008 2:01:25 AM UTC+5:30, Thomas Mueller wrote: >> >> Hi, >> >> > How to parse this date and time without error ? >> >> See >> http://h2database.com/html/**functions.html#parsedatetime<http://h2database.com/html/functions.html#parsedatetime> >> >> Regards, >> Thomas >> >> -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/h2-database/-/lDV4mAJexIoJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
