Re: DateTime NOW()

Jacque Scott [EMAIL PROTECTED] wrote: I have a DateTime data type for one of my fields. If an entry is being INSERTed then I want the DateTime to be NOW(). I want this done automatically and not have to set me SQL str to do this. I have tried to set the default as NOW() but it will insert

DateTime NOW()

I have a DateTime data type for one of my fields. If an entry is being INSERTed then I want the DateTime to be NOW(). I want this done automatically and not have to set me SQL str to do this. I have tried to set the default as NOW() but it will insert -00-00 ... I don't want this, I want

DateTime NOW()

I have a DateTime data type for one of my fields. If an entry is being INSERTed then I want the DateTime to be NOW(). I want this done automatically and not have to set me SQL str to do this. I have tried to set the default as NOW() but it will insert -00-00 ... I don't want this, I want