Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread
Message: 64934
BY: Nathan Wiebe (nwiebe)
DATE: 2009-02-18 21:00
SUBJECT: TIMESTAMP columns and CURRENT TIMESTAMP

 

Hi, is there any officially supported way to get ibm_db to insert a value of CURRENT TIMESTAMP (or similar) into a timestamp column? ibm_db 1.0.1 turns CURRENT TIMESTAMP into "CURRENT TIMESTAMP", which is not valid DB2 syntax.

I modified ibm_db-1.0.1-x86-mswin32/lib/active_record/connection_adapters/ibm_db_adapter.rb to not add the quotes around values beginning with CURRENT for timestamp columns. Any chance of adding official support for this? What about getting ActiveRecord to use CURRENT TIMESTAMP for CREATED_AT and UPDATED_AT columns, instead of using the time from the client machine?

Nathan


Thread View

Thread Author Date
TIMESTAMP columns and CURRENT TIMESTAMPNathan Wiebe2009-02-18 21:00
      RE: TIMESTAMP columns and CURRENT TIMESTAMPPraveen Devarao2009-02-19 05:29

Post a followup to this message