Home Forums SQL Server 7,2000 T-SQL how to add one second RE: how to add one second
lindss01
SSCrazy
Points: 2264
More actions
December 27, 2004 at 10:52 am
#535063
Why do you want to do this? What are the requirements?
Here is a fun "Select"
SELECT DatePart(s, Getdate()), DatePart(s, Getdate()) + 1, GetDate(), DateAdd(s, 1, GetDate())