Hi, See the documentation at http://h2database.com/html/functions.html#parsedatetime
Regards, Thomas On Mon, Oct 22, 2012 at 11:51 AM, priyanka priya <[email protected]>wrote: > 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. > -- 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.
