[AccessD] SQL Server Date Time

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon Jul 19 11:24:18 CDT 2010


I have a database linked to an SQL server table that has a date time column. I want only the date and the hour portion rounded to the nearest hour. For example

7/18/2010 1:41:00 AM becomes 7/18/2010 2:00:00 AM

Thanks 

Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.





More information about the AccessD mailing list