Hello,
Try TimeFormat (and DateFormat if you want date)
#TimeFormat(query.columnname, "hh:mm tt")#
Scott M. Berry :: [Staff Developer]
annex.com, Inc. - http://www.annex.com/
----- Original Message -----
From: "Kevin Willyerd" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 20, 2000 8:54 AM
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
