Forums | Admin

Discussion Forums: open-discussion

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 TIMESTAMP Nathan Wiebe 2009-02-18 21:00       RE: TIMESTAMP columns and CURRENT TIMESTAMP Praveen Devarao 2009-02-19 05:29