Gossamer Forum
Home : General : Databases and SQL :

problem with timestamp

Quote Reply
problem with timestamp
the first field in my table is a timestamp which i want automatically filled with current date/time when i add a new record, as well as modify existing record. the modify works fine, but add fills with 0s. add works ok until i use the Resync Database function in Admin. this changes default to CURRENT_TIMESTAMP and changes NOT NULL to NO. when i have NOT NULL = YES and blank default value, it works. why does resync change these properties and is there something i can put in default that will work?
Subject Author Views Date
Thread problem with timestamp delicia 8871 Aug 7, 2010, 6:27 AM
Thread Re: [delicia] problem with timestamp
Andy 8622 Aug 7, 2010, 7:00 AM
Thread Re: [Andy] problem with timestamp
delicia 8641 Aug 7, 2010, 7:51 AM
Thread Re: [delicia] problem with timestamp
Andy 8623 Aug 7, 2010, 7:53 AM
Post Re: [Andy] problem with timestamp
delicia 8603 Aug 7, 2010, 8:10 AM