[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Order by date (MM/DD/YYYY)

Larry,

In Oracle there's a TRUNC function that would do this - ORDER BY TRUNC(MYDATE)- 
not sure if this is unique to Oracle or if it works in SQLServer.

Jay

-----Original Message-----
From: McCown, Larry [mailto:larry.mccown@ngc.com]
Sent: Thursday, February 12, 2004 9:54 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Order by date (MM/DD/YYYY)


Hello All,
I have a date field that includes hours and minutes and I am trying to get
my order by to only look at the mm/dd/yyyy.  Suggestions?
Thank you in advance for your time.
VisualSqribe 5.0
Maximo 4.0.3
SQLServer 7.0
 
Larry  *
Larry McCown
Northrop Grumman
Western Region Facilities
One Hornet Way WG00/W5
El Segundo, Ca. 90245
Phone (310)628-3939
Fax      (310)332-3149
 <mailto:Larry_McCown@NorthropGrumman.com> 
Larry.McCown@NGC.com <mailto:Larry.McCown@NGC.com> 
Opportunities to be kind are never hard to find.
Words kill, words give life; they're either poison or fruit - you choose.
 
 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users