Priyanka, It seems to me that you requirement is to _format_ a date, not to _parse_ a date.
Here is the function to format a date: http://h2database.com/html/functions.html#formatdatetime On Monday, 22 October 2012 11:51:24 UTC+2, priyanka 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]<javascript:> > > 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]<javascript:> >> . >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> 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 view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/9frdHrEyK4oJ. 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.
