General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Sorry for the thick-headedness.
You mean you're human?? ;>} (Guy quoted below claims he's Borg!)
>In Oracle, there is a function called MONTHS_BETWEEN
>
>There is another function called ADD_MONTHS
Rdb takes only ANSI SQL-92 functions and commands. I got the following from the MSFT NG:
"According to Joe Celko there is a section for handling date/time data types
in the SQL-92 specification. However, because of the complexities no vendor
has implemented these specs yet. This information was copyrighted in 1995
and is contained in the book, SQL for Smarties: Advanced SQL Programming.
Chapter 4 deals with date/time issues and how to implement some simple date
arithmetic."
What I will be doing is getting more data than I need and doing some Fox date-handling locally. Here's to work-arounds!!
Also, I have the 2nd Edition of Celko's book (published 7/99 ! ) on order.
Thanks for your attention.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only