I have a query i join it based on an id number and a date. The date is in the long format where it goes out to the seconds. problem is that the transactions are off by 1 second and i can't group them properly. Is there a way where I can compare the dates only by the month,day,year,hours, and minutes and take off the seconds in the time. so i only want: 7/16/2003 12:00 PM. Thanks for the help. oh yeah i'm doing this within a query.
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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date formatting question
- Thread starter trifest
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
