How can I query an Oracle Date field as an int? I am trying to find rows that are 3
days old and the date fields in Oracle are timestamps. I need to some how ignore the
time in the date field in the query
This is what I have tried:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
How can I query an Oracle Date field as an int? I am trying to find rows
that are 3 days old and the date fields in Oracle are timestamps. I need to
some how ignore the time in the date field in the query
This is what I have tried:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
Subject: Re: Oracle Date Querry
How can I query an Oracle Date field as an int? I am trying to find
rows
that are 3 days old and the date fields in Oracle are timestamps. I need to some how
ignore the time in the date field in the query
This is what I have tried:
cfquery name=Thirdday
As you can probably figure out I am very new to this. I tried your query
and it did give me a date of three days ago. How would I implement this in
my query?
Something like this should be what you're looking for:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
FROM
Dave,
Thank you !! Works like a charm.
-Patrick
Something like this should be what you're looking for:
cfquery name=Thirdday datasource=badge_access_dsn
SELECT *
FROM SPS_NON_MOT_BPS.SITES
WHERE ((trunc(CREATION_DATE) = trunc(sysdate-3) AND Badging_status = 'In Approval
Cycle') OR
5 matches
Mail list logo