CODEWITHSUNDEEP
sqloracle-databasetimestampformat
Imran Hemani
Imran Hemani

Reputation: 629

Oracle SQL Timestamp format

I have a timestamp field in the database to which i need to format as:

2003-08-09T05:48:37+05:30

How to do this formatting?

Upvotes: 2

Views: 958

Answers (1)

Husqvik
Husqvik

Reputation: 5809

SELECT TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM') FROM DUAL

Upvotes: 8

Related Questions