Hi,
How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table
I'm using Enterprise Manager in MSSQL
Many Thanks
Hi,
How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table
I'm using Enterprise Manager in MSSQL
Many Thanks
Jump to Postcreate table tblname (
fieldname datetime default getdate()
)
In the column definition: default value = now()
Thanks will try it
Hi,
How do I design a table column named UpdateDate that will give the default date and time upon inserting a record into the table
I'm using Enterprise Manager in MSSQL
Many Thanks
It doesn't work for me. I have an error message when trying to use now().
create table tblname (
fieldname datetime default getdate()
)
In the column definition: default value = now()
Err: user must input default value to = ( getdate() )
With this SQL will insert the date + time everytime someone inserts values in that columns.
Hi,
I have created two columns in the DB and I want to insert fill these two columns with current datetime.How Can I do It,Please reply
CheckInTime datetime,
CheckOutTime datetime
insert CheckTime values(1,'','',and what should I do for the datetime)
Thank you.
Regards.
I just Passes
GetDate()
and its works Thank You
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.
You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed. It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post.