Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

DateTime Functions Expand / Collapse
Author
Message
Posted Wednesday, April 4, 2012 8:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:43 AM
Points: 34,177, Visits: 18,330
Comments posted to this topic are about the item DateTime Functions






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1278522
Posted Wednesday, April 4, 2012 8:26 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 18, 2016 9:14 PM
Points: 1,369, Visits: 1,215
Nice !!!. Good to learn knew stuff !!!!.
Post #1278527
Posted Wednesday, April 4, 2012 9:35 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Friday, September 23, 2016 10:17 PM
Points: 20,008, Visits: 18,244
I like it - keep em coming.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1278548
Posted Wednesday, April 4, 2012 9:41 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 23,348, Visits: 37,348
Definately a good question.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1278550
Posted Wednesday, April 4, 2012 10:59 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, September 17, 2016 5:25 AM
Points: 1,699, Visits: 2,095
Nice question, Thank-you, Steve! Learnt something new.

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1278573
Posted Wednesday, April 4, 2012 11:18 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 6:25 AM
Points: 15,386, Visits: 13,121
Great question, thanks. I never use this datatype though.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1278575
Posted Thursday, April 5, 2012 2:37 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 3,314, Visits: 3,151
Good question!
Thanks.
Post #1278625
Posted Thursday, April 5, 2012 4:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 12, 2016 6:33 AM
Points: 1,216, Visits: 311
Nice Question!
Post #1278680
Posted Thursday, April 5, 2012 5:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, May 31, 2016 4:13 PM
Points: 2,107, Visits: 2,254
Thanks Steve! We currently code for locations in one time zone, so we don't use these types of things much. However, we recently became part of a global enterprise and will have to start doing so. Time zone considerations and collation considerations will finally become important to us, and not just as QOTD's.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1278702
Posted Thursday, April 5, 2012 7:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, September 17, 2016 8:01 AM
Points: 2,834, Visits: 2,629
Had to read a bit to figure it out, learned something. Thanks.
Post #1278786
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse