Skip to content

Instantly share code, notes, and snippets.

@ojacobson

ojacobson/gist:4711075

Created February 5, 2013 00:30
Show Gist options
  • Save ojacobson/4711075 to your computer and use it in GitHub Desktop.
Save ojacobson/4711075 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
scratch=# select to_char(now(), 'HH24:MI:SS.MS');
to_char
--------------
19:28:41.876
(1 row)
scratch=# select to_char(now(), 'THH24:MI:SS.MS');
to_char
---------------
T19:28:48.141
(1 row)
scratch=# select to_char(now(), 'DDTHH24:MI:SS.MS');
to_char
-------------------
04THH24:28:54.614
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment