October 7, 2014 at 8:18 am
Hi,
I have access to an unknown database via a third party ODBC driver, but can't get a response (two weeks and counting) from the company which host the database.
I need to limit the amount of data being returned (via SSIS on 2008R2) to the previous days data but don't know the syntax of the today() function, doing an internet search of this does not yield anything useful.
So, does anyone know which database uses Today()?
I'm pretty sure it's not Oracle 9+ as rownum does not work, it's not SQL because TOP n does not work. It could be "Oracle Rdb" because "limit to n rows" works, however today() is not a known function in that database.
This works and returns 10 rows:
select * from blah where someDate=today() limit to 10 rows;
Could be a user defined function I suppose.
Anyone seen this as a built in function of a database before?
October 7, 2014 at 8:26 am
thedavegray (10/7/2014)
Hi,I have access to an unknown database via a third party ODBC driver, but can't get a response (two weeks and counting) from the company which host the database.
I need to limit the amount of data being returned (via SSIS on 2008R2) to the previous days data but don't know the syntax of the today() function, doing an internet search of this does not yield anything useful.
So, does anyone know which database uses Today()?
I'm pretty sure it's not Oracle 9+ as rownum does not work, it's not SQL because TOP n does not work. It could be "Oracle Rdb" because "limit to n rows" works, however today() is not a known function in that database.
This works and returns 10 rows:
select * from blah where someDate=today() limit to 10 rows;
Could be a user defined function I suppose.
Anyone seen this as a built in function of a database before?
The only place I have ever seen TODAY() is in VBA. Is the application written in VBA??
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 7, 2014 at 8:30 am
Hi,
Thanks for the response. I doubt it to be honest, pinging the server reports that it's on an Alpha Server running OpenVMS.
The ODBC driver is by Attunity who specialised in VMS stuff I think.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply