slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - T-SQL & Queries
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to T-SQL & Queries | New Thread

View: Search:

Author

Thread: Oracle Dates

Ian Fitzpatrick
Posts: 146

Oracle Dates Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Aug 08 4:23 PM

I am accessing an Oracle database with the MS Oracle driver to get a result set that I will be importing into SalesLogix and I am not very familiar with Oracle syntax, and I'm hoping someone can help me out.

I would like all the records that were created after 5PM yesterday. At Present I have (DBO.T_EISD_SALESDOWNLOAD.SD_TIMESTAMP
> current_date - 1)
but that will give me all the records since yesterday at midnight.

Can someone help me?
Thank you,

[Reply][Quote]

Walter Shpuntoff
Posts: 167

Re: Oracle Dates Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Aug 08 5:05 AM

Ian,

I am assuming that your field DBO.T_EISD_SALESDOWNLOAD.SD_TIMESTAMP is actually an Oracle TIMESTAMP field....

So what you do is build an ISO string with your date/time and then use TO_TIMESTAMP so you are comparing like types.

So currentdate - 1 becomes

TO_TIMESTAMP('" & Application.BasicFunctions.DateToISO(DateAdd("d", -1, Now)) & " 17:00:00', 'YYYYMMDD HH24:MI:SS')"

Got it?

ws

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 9:48:10 AM