Hi. I have a table with datetime field. In which format should i have to send datetime in REST request to insert/update in table?
Thanks Kate!
Hi, Andres. You can use timestamp or datetime with this formats:
yyyy-MM-dd’T’hh:mm:ss.SSS’Z’
MM/dd/yyyy HH:mm:ss z
MM/dd/yyyy HH:mm:ss ‘GMT’Z
MM.dd.yyyy HH:mm:ss z
MM/dd/yyyy HH:mm:ss
MM/dd/yyyy
MM.dd.yyyy HH:mm:ss
MM-dd-yyyy HH:mm:ss
dd/MMM/yyyy
dd-MMM-yyyy
EEEEE, d MMMMM yyyy
ddMyy
d MMMMM yyyy, HH’h’ mm’m’ ss’s’
yyyy/MM/d/hh:mm:ss
yyyy-MM-dd’T’hh:mm:ss
EEEEE, MMMMM d, yyyy
MMMMM d, yyyy
yyyy-MM-dd
yyyy M d
yyyyMMMd
yyyy-MMM-d
yyyy-M-d, E
yyyyMMdd
‘Date’ yyyy-MM-dd
yyyy-MM-dd’T’hh:mm:ssZ
yyyy-MM-dd’T’hh:mmZ
yyyy-'W’w-d
yyyy-DDD
Regards, Kate.