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

["George Jansen" <GJANSEN@aflcio.org>]

If you're ordering by the date field including hours & minutes then
you're ordering by any lesser precision of that field. 

If however you mean that you want to order by date, then something
else, like name, how about

Day(datefield)

>>> jwomeldo@fastenal.com 02/12/04 10:04AM >>>
Larry,

If you are using Oracle try 
order by trunc(thedate)

Jim

-----Original Message-----
From: McCown, Larry [mailto:larry.mccown@ngc.com] 
Sent: Thursday, February 12, 2004 8: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

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