Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JChanana

  1. JChanana

    Datetime

    Is there a way I can query on just the date or just time element in the datetime datatype? I didn't see an option using datepart. Must I use the convert? Is there another option like truncating the time or date out?
  2. JChanana

    GMT and local time conversion

    Is there a way in SQL Server to convert GMT time to a local time by designating a time zone. I do not want to convert to the antive time zone but identifya time zone to conver to. I believe GMDATE convert to GMT, I need to convert from GMT to local time given time zone (this needs to take into...
  3. JChanana

    Time plus int

    How do I take a datetime datatype (with a time only populated) and add a integer (where the data is already recorded in minutes) and add the two for the new time? Is there a conversion or a function that will help with this?
See more

Part and Inventory Search

Back
Top