20090831 whats the system time on that db - plembo/onemoretech GitHub Wiki

title: What's the system time on that db? link: https://onemoretech.wordpress.com/2009/08/31/whats-the-system-time-on-that-db/ author: lembobro description: post_id: 262 created: 2009/08/31 19:20:27 created_gmt: 2009/08/31 19:20:27 comment_status: open post_name: whats-the-system-time-on-that-db status: publish post_type: post

What's the system time on that db?

Needed to check this today to make sure an apps db wasn’t out of sync with its corresponding infrastructure partners.

SQL> SELECT TO_CHAR(SYSDATE , 2 'Dy DD-Mon-YYYY HH24:MI:SS') as 3 "Current Date/Time" FROM DUAL;

It’s little stuff like this that can make you crazy.

NTP was invented back around 1980 by Dave Mills at the University of Delaware. What excuse anyone has for not running it on all their servers and clients is… well, there is no excuse.

Of course we’ve still got the UT/GMT vs. Local Time thing to content with. Personally, if I had access to a time travel machine one of the things I’d do is go back and find some way stop that first implementation of local time on computers.

Then I’d move on to preventing anything but 7-bit ASCII from ever being displayed on terminals…