0

I have an XML file that has this parameter:

<parameter name="date_time" datatype="xsd:int">
   <val>1464789198</val>
</parameter>

which I have to convert to datetime using SQL.

I have searched for it, its likely to be an ISO8601

Milo P
  • 1,285
  • 2
  • 33
  • 37
Diego Ofernando
  • 1
  • 1
    There is no such format in ISO-8601. It is likely to be something like seconds since the UNIX Epoch (1970-01-01T00:00:00). – Richard Jun 01 '16 at 15:55
  • As Richard said, that's almost certainly a Unix timestamp--it evaluates to Wed, 01 Jun 2016 13:53:18 GMT. See here for more info (if you're using mysql): http://stackoverflow.com/questions/21569556/how-to-convert-the-unix-time-into-sql-datetime-format – Milo P Jun 01 '16 at 16:01

0 Answers0