Forum Discussion

ajupulickal's avatar
ajupulickal
Copper Contributor
May 10, 2022

SQL Date Formatting

Hi all,   I have a requirement to do an OpenQuery to an Oracle database and the accepted time format in Oracle is "2022-05-01T06:00:00Z". I am wondering how do we convert a normal datetime in SQL s...
olafhelper's avatar
olafhelper
Bronze Contributor
May 11, 2022

 

ajupulickal wrote:

Oracle database and the accepted time format in Oracle is "2022-05-01T06:00:00Z"

ajupulickal , no it isn't, with the to_date function you can pass any date format to Oracle.

See

TO_DATE (oracle.com)

 

Resources