Jun 12

Timestamp in Oracle

sql oracle

Oracle SQL Developer application doesn't know how to handle invalid timestamps, so I set them to unixtime 0 instead of 0.

update merchants
set updated_at = timestamp('1970-01-01 10:00:00')
where updated_at = 0
;
✱ ✱ ✱