Re: help function for difference date in ggmmyyhhmm

I don't think there is such a date format in Oracle as 'gg'.

You can just subtract two dates in the standard format, or make another character value into a date format:

select (to_date('myvalue1','YYYYMMDD')-to_date('myvalue2','YYYYMMDD')) from dual;

Is that what you are after? Pretty much as long as you specify what your format is, you can make just about any character value (within reason) into a date and once they are in a date format, you can subtract one from another.

-- 
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

gabriele <asmvo_at_alfieri.voghera.pv.it> wrote in article
<01bdaa8c$2591d6e0$6c150180_at_masso.ASM>...


> have You a function to return in format "ggmmyyhhmm" a difference between


> two date? 

> Thanks you.

> 

> 

> 				G.Massocchi

> 

> 					 

>