Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 17th, 2012  |  syntax: None  |  size: 0.25 KB  |  hits: 23  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to insert current_timestamp into Postgres via python
  2. INSERT INTO some_table
  3.  (ts_column)
  4.  VALUES
  5.  (TIMESTAMP '2011-05-16 15:36:38');
  6.        
  7. INSERT INTO some_table
  8.  (ts_column)
  9.  VALUES
  10.  (to_timestamp('16-05-2011 15:36:38', 'dd-mm-yyyy hh24:mi:ss'));
create a new version of this paste RAW Paste Data