79215124

Date: 2024-11-22 13:06:36
Score: 1
Natty:
Report link

Try this please:

from integer: SELECT FROM_UNIXTIME(timestamp_column / 1000) AS converted_date FROM your_table;

from string: SELECT string_timestamp, TO_TIMESTAMP(string_timestamp, 'yyyy-MM-dd HH:mm:ss') AS timestamp_with_time FROM your_table;

Reasons:
  • Whitelisted phrase (-1): Try this
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Александр Каминский