How do I extract the date/timestamp from values such as “2020-06-19T21:23:26.990971”?

Aarthi
Aarthi
  • Updated

You can use CAST to extract parts of the timestamp values:

# entry$raw table
review_requested_at 
2020-06-19T21:23:26.990971 |
2020-06-25T18:38:34.777950 |

# SQL query
SELECT CAST(se.review_status_changed_at AS DATE) as "Date Task Completed"

# Output
Date Task Completed
2020-06-19 |
2020-06-26 |

Was this article helpful?

Have more questions? Submit a request