try this :
TimePublish <= #TimeFormat(GetDate(),'HH:MM')#
----- Original Message -----
From: "S R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 31, 2001 9:25 AM
Subject: one more sql question
> Is there anyway to compare times in SQL? I have a page that I would only
> like to output press releases that are less than or equal to the current
> date and time.
>
> I know how to compare dates but not times:
>
> SELECT DatePublish, PressReleaseTitle, PressID, DatePublish, TimePublish
> FROM PressReleaseTitles
> WHERE DatePublish <= GetDate()
>
> SR
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
