Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

poor explanation Expand / Collapse
Author
Message
Posted Sunday, April 6, 2008 11:34 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 12:21 PM
Points: 286, Visits: 257
Poor explanation of the answer, the author just assumed that FEB is = FEBRUARY and also the DOB = DOJ.
I need my points desperately.




- Manish
Post #480594
Posted Monday, April 7, 2008 3:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 1, 2010 1:46 AM
Points: 102, Visits: 23
DOB???
Not a good question.

By the way DATENAME(datepart, date) returns 'February' when datepart is month and month(date) is 2...
so the second one is right.



Post #480652
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse