Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in SQL Server only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Member List
Calendar
Today's Posts
Home
Forum
Topic
SQL Server
How to change date of a variable which shows date in UTC format
How to change date of a variable which shows date in UTC format
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
sanjasmine
New Member
Join Date:
May 2010
Posts:
1
#1
How to change date of a variable which shows date in UTC format
May 27 '10, 08:07 AM
Is it possible to subtract a few hours from the variable which shows date in UTC format
deepuv04
Recognized Expert
New Member
Join Date:
Nov 2007
Posts:
227
#2
May 27 '10, 09:10 AM
Originally posted by
sanjasmine
Is it possible to subtract a few hours from the variable which shows date in UTC format
dateadd(hh,-N,@Date_Variabl e)
here N is number of hours
Comment
Post
Cancel
Previous
template
Next
Working...
OK
OK
Cancel
👍
👎
☕
Comment