It seems to me you would need to store the string in the db, as the actual
amount of time would be different in different circumstances. e.g. for a
month you can't simply store 30 or 31 or 28....
Perhaps you could store something like: 0:0:0:0:1:0:0:0:0:0 (for one month)
Hmm, just needs a cool UDF....
----- Original Message -----
From: "Brian Scandale" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 9:09 AM
Subject: Re: SQL server and Interval data type
> 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
> >
> >
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
