asked on SQL Server - Column Update
Hello All,
I have a SQL Server Question. I am not sure which the best way to do it is. Now the requirement:
Every time, a new row(s) is inserted to my table xyz, then there is column in that table, called [update time], that gets the time of update in the format below…
For example – server Table
col1 col2 col3 updateTime
dsas sdads sdad 12/04/2012 1.45 PM
dsas sdads sdad 12/04/2012 1.50 PM
Is this difficult to accomplish?
Thanks
R
I have a SQL Server Question. I am not sure which the best way to do it is. Now the requirement:
Every time, a new row(s) is inserted to my table xyz, then there is column in that table, called [update time], that gets the time of update in the format below…
For example – server Table
col1 col2 col3 updateTime
dsas sdads sdad 12/04/2012 1.45 PM
dsas sdads sdad 12/04/2012 1.50 PM
Is this difficult to accomplish?
Thanks
R
Microsoft SQL ServerMicrosoft SQL Server 2008
Last Comment
Rayne
ASKER
Also, [updateTime] column has to be of any specific format for achieving this?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect Anujnb,
That works but I am getting the date format as below:
Jan 2 2013 2:18AM
is it possible to get it like this?
01/02/2013 2:18AM
Thanks for your help so far :)
That works but I am getting the date format as below:
Jan 2 2013 2:18AM
is it possible to get it like this?
01/02/2013 2:18AM
Thanks for your help so far :)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you All for your excellent 5 ***** help :)
For your effort.
Greatly appreciate it
For your effort.
Greatly appreciate it
If this is a date time column I recommend you to Insert the date time value with default format and while retrieving the values convert to the required format. This method has the advantage that you can do date manipulations to the date time column with out the requirement of any conversion and of-course the performance adv also.
SELECT CONVERT(VARCHAR,GETDATE(),
SELECT CONVERT(VARCHAR,UpdateTime
FROM <YourTable>
SELECT CONVERT(VARCHAR,GETDATE(),
SELECT CONVERT(VARCHAR,UpdateTime
FROM <YourTable>
ASKER
thank you Anuj :)
Sure I will keep that in mind
Sure I will keep that in mind