Top "To-date" questions

Convert text to timestamp in redshift

I have a text field "presence_changed_at" with text values i.e. '2014/12/17 08:05:28 +0000. I need to convert this into …

amazon-redshift to-date to-timestamp

ORA-01861: literal does not match format string

I'm pretty sure this is something really silly. Instead of spending another 10 minutes with this ( or better said, while I …

sql oracle oracle9i ora-01861 to-date

oracle insert only time

I would like to insert data to db as time, not date. If I use to_date('2012-08-31 07:39:33…

oracle time to-date

Function "TO_DATE" not found in H2 database

I have a SQL statement and trying execute with H2 in-memory database in Java. The following exception thrown. SQL: SELECT …

java sql h2 to-date

Oracle Get only time from To_Date() in a Query?

I have an insert query: INSERT INTO THE_TABLE (Field_A) VALUES (TO_DATE('08/12/2011 08:35:42 AM','HH:MI:SS PM')) …

sql oracle to-date

postgresql cast numeric to date and format

I have my date field as numeric in postgresql and the values in the date are like 1401710352000 and when I …

postgresql type-conversion to-date

how to display number value in words

Q. Display the number value in Words and output should look like this SAL In_Words --------- ----------------------------------------------------- 800 eight hundred 1600 …

sql oracle type-conversion to-date to-char

ORA-01830: date format picture ends before converting entire input string in TOAD

I have a script in which I am writing functions and procedures. The script works absolutely fine in Oracle SQL …

oracle function datetime toad to-date

What exact exception to be caugth while calling TO_DATE in pl/sql code

I have below code to_date('1311313', 'yymmdd') which actually throws exception with saying invalid month. Which is can …

oracle exception plsql to-date

Oracle to_date function. Mask needed

I have string of date from xml file of such kind: '2010-09-09T22:33:44.OZ' I need to extract …

oracle format mask to-date