Ahh yes Jochem... so true, However my puzzle still remains... what/how is that handled
in SQL Server... I did notice that one source says to import interval data into SQL
server set up a char field....
Now I'm wondering how that would work inside CF... trying to process it that is...
At 09:12 PM 4/16/02 +0200, you wrote:
>Mark A. Kruger - CFG wrote:
>> Ok - explain the interval data type. what is it and what does it contain?
>
>Interval data type contains an interval (copy/paste from manual):
>Type interval [ (precision) ]
>Description for time intervals
>Storage 12 bytes
>Earliest -178000000 years
>Latest 178000000 years
>Resolution 1 microsecond
>
>Usage:
>Quantity Unit [Quantity Unit...] [Direction]
>Quantity: number
>Unit: second, minute, hour, day, week, month, year, decade,
>century, millennium, or abbreviations or plurals of these units;
>Direction: empty or "Ago"
>
>Examples:
>'1 12:59:10'
>'1 day 12 hours 59 min 10 sec'
>'1 day 10 sec'
>'16 centuries 1 sec'
>SELECT datefield + 5 * intervalfield - Cast('1 sec' AS INTERVAL) AS duedate
>etc.
>
>PostgreSQL Date/Time handling is cool and compliant :-)
>
>Jochem
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
