Forum Discussion

Dobhal005's avatar
Dobhal005
Copper Contributor
Jun 13, 2022

How Date is stored internally in Synapse DB

Hello Everyone,

In which format do Synapse DB stores date?
Is it YYYY-MM-DD or YYYY-MM-DDT00:00:00.000000?
I have seen it storing the date in the latter format? I tried casting it as well but no luck.
So I am guessing it internally stores it in YYYY-MM-DDT00:00:00.000000 format.
Can someone please explain this behavior?

 

Thanks in Advance

1 Reply

Resources