How I can insert with a query a date like this? 2015-06-02T11:18:25.000 I have tried this: But I have returned: I tried also: but it is not working: The entire query is: What is wrong? Answer Try this: 126 relates to ISO8601, which is the format yyyy-mm-ddThh:mi:ss.mmm. This is the same format as the string ‘2015-06-02T11:18:25.000’. For more information, see
Tag: datetime-format
Convert timestamp/date time from UTC to EST Oracle SQL
I have a field with a date/time value like this: It’s in UTC. In the query how can I convert this to EST? I’m trying something like this but it throws an error. Answer I had to tweak it slightly to get it to work on my database, but this worked: The key is the “at time zone” syntax.