You can do this in SQL: RIGHT(RTRIM(CONVERT(char,<your date field>,100)),7) In CF, look at TimeFormat and the tt mask. -----Original Message----- From: Kevin Willyerd [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 10:55 AM To: CF-Talk Subject: OT: SQL Time formats Hey all, I have a field stored as a smalldatetime in SQL 7. Using the convert function I can pull out the time in the format of hh:mm (Convert(char(5),dbo.event.datetime,8) as Time). How do I have the output of the time in the format hh:mmAM (or PM)? I am taking what I have now and converting it using cold fusion functions. Kevin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
