Access Query w/ Unix Date Criteria

I have a pass through query that pulls information from an oracle
datasource.  I need to be able to set a date critera for a field in my
query.  For Example I want to only pull data where RES_DATE is greater
than 12/01/2003.  The RES_DATE field type is some unix time (example-
1072881348)  I have tried just setting normal data critera in the
access query but it doesnt like the format.  Does anybody know how to
set this type of criteria?  Any help is appreciated-Corey
0
cflemi05
12/17/2003 9:57:39 PM
access.conversion 3037 articles. 0 followers. Follow

1 Replies
770 Views

Similar Articles

[PageSpeed] 28

The Unix Date is the number of seconds since January 1st, 1970.

To convert from a regular date to a Unix date, use DateDiff("s", #1/1/1970#,
Date())

To convert from a Unix date to a regular date, use DateAdd("s", UnixDate,
#1/1/1970#)

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"CDF" <cflemi05@sprintspectrum.com> wrote in message
news:5cbef661.0312171357.22bd15ec@posting.google.com...
> I have a pass through query that pulls information from an oracle
> datasource.  I need to be able to set a date critera for a field in my
> query.  For Example I want to only pull data where RES_DATE is greater
> than 12/01/2003.  The RES_DATE field type is some unix time (example-
> 1072881348)  I have tried just setting normal data critera in the
> access query but it doesnt like the format.  Does anybody know how to
> set this type of criteria?  Any help is appreciated-Corey


0
Douglas
12/17/2003 10:33:32 PM
Reply:

Similar Artilces: