Hi all
I'm trying to write a query to find records matching today's date. What
I have is:
<CFSET timestamp = #DateFormat(now(),"yyyy-mm-dd")#>
<!--- find based on date --->
<CFQUERY DATASOURCE="#SESSION.dsn#" NAME="gm_drawings_bydate">
SELECT
*
FROM
uprr_drawings dwg
WHERE
dwg.mod_date = #timestamp#
</CFQUERY>
>From the table, the data looks like this:
1/5/2001 22:42:09,
11/13/2000 07:47:16
and so on ...
All ideas appreciated!
* john *
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists