willwillis
Reputation: 118
insert now() into a Sybase timestamp field
I'm new to sybase and google was anything but helpful. All I want to do is insert a valid time for "right now" into a timestamp field. The mysql equivalent is now(). I tried getdate() and got funny results.
Thanks.
Upvotes: 1
Views: 7614
Answers (1)
David
Reputation: 73554
You can't insert data into a timestamp column.
Added
I should have included this right away to be nice, but a Timestamp field is updated to the current date/time automatically when a row is modified.
Upvotes: 3
Related Questions
- INSERT datetime using now() with Go
- Insert current date/time using now() in a field using MySQL/PHP
- Get current time without Date
- How to add time to a date in Sybase?
- Inserting NOW() value in datetime datatype is returning 0000-00-00 00:00:00
- MySQL insert with the current timestamp
- INSERT current date or time into MySQL
- How to get the current datetime in add column script in sybase
- make a column in sybase default to the current date/time of row insertion
- Datetime Equivalent of Date(Now()) for Insert