(phili.pe)

1. cpeterso ◴[31 Mar 19 00:04 UTC] No.19532799[source]▶

What timestamp types are available in MySQL, SQL Server, and Oracle?

2. tyingq ◴[31 Mar 19 00:23 UTC] No.19532853[source]▶

Be careful with the MySQL ones. A couple of them overflow past 1-1-2038, which would break some use cases now. https://bugs.mysql.com/bug.php?id=12654

3. ◴[31 Mar 19 00:38 UTC] No.19532902[source]▶

4. emmelaich ◴[31 Mar 19 01:52 UTC] No.19533224[source]▶

Dunno but sqlite3 assumes times are in utc.

5. userbinator ◴[31 Mar 19 03:18 UTC] No.19533575[source]▶

SQL Server has datetimeoffset, which computes in UTC but also stores the timezone.

replies(1): >>19534190 #

6. niftich ◴[31 Mar 19 04:15 UTC] No.19533819[source]▶

Oracle has 'DATE', 'TIMESTAMP', 'TIMESTAMP WITH TIME ZONE', and 'TIMESTAMP WITH LOCAL TIME ZONE'.

Out of these, 'TIMESTAMP' and 'TIMESTAMP WITH TIME ZONE' do exactly what you'd expect without needing a big tutorial.

'DATE' is a 'TIMESTAMP' that can't store fractional seconds.

And 'TIMESTAMP WITH LOCAL TIMEZONE' is an unmitigated footgun that you'll probably misuse.

7. crooked-v ◴[31 Mar 19 06:19 UTC] No.19534190[source]▶

Does it store the time zone, or does it store the offset?

replies(1): >>19535099 #

8. GordonS ◴[31 Mar 19 11:44 UTC] No.19535099{3}[source]▶

AFAIK, it stores the offset

Timestamps and Time Zones in PostgreSQL (2016)