Menu
There is a SQL function from Oracle to_date('26 Jul 2016, 05:15:58 AM','DD Mon YYYY, HH:MI:SS AM'), and it throws exception "Illegal pattern character 'o'" in H2.
How shall I change it to make it work in H2?
687
asked Jul 26 '16 09:07
In SQL Server, converting a string to date explicitly can be achieved using CONVERT(). CAST() and PARSE() functions.
MySQL STR_TO_DATE() Function The STR_TO_DATE() function returns a date based on a string and a format.
The format is hh:mm:ss[. nnnnnnnnn].
The CAST() function in MySQL is used to convert a value from one data type to another data type specified in the expression. It is mostly used with WHERE, HAVING, and JOIN clauses. This function is similar to the CONVERT() function in MySQL. It converts the value into DATE datatype in the "YYYY-MM-DD" format.
The equivalent function of TO_DATE() in H2 is PARSEDATETIME().
This is how you should use it with your sample data:
PARSEDATETIME('26 Jul 2016, 05:15:58 AM','dd MMM yyyy, hh:mm:ss a','en')
Be careful not to use HH:mm:ss otherwise the AM/PM detection will not work.
144
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
