Tema: Re: oracle select uzklausa
Autorius: 2x50
Data: 2011-03-22 12:04:07
with x as (select to_timestamp(sysdate) ts1, to_timestamp(sysdate+1) ts2 
from dual)

select sum(cast(ts2 as date)-cast(ts1 as date)) from x

"news" <netikrasmailas@gmail.com> wrote in message 
news:im9rol$5al$1@trimpas.omnitel.net...
> prie to pacio:
> turiu timestamp1 ir timestamp2
> man reikia atlikti operacija sum(timestamp1-timestamp2)
> kaip tai padaryti?
+mysqlimport referencial integrityneklausiu2011-04-19 12:43
+kas blogai su web/mysql encodingu?Herkus2011-04-15 10:59
+Pagalba su RTE200 dos@Vitalijus2011-04-15 08:56
COMM: Enterprise Security Architecture: A Business-Driven ApproachdjPasco2011-04-13 00:16
+MS Excel reikšmė pagal rėžiusGiedrius 2.52011-04-06 15:05
.NET, EPiServerAuris2011-04-06 09:54
+Programa uzsidare-=Valdas=-2011-04-06 07:49
+Linksniavimasbertas2011-04-04 23:48
+design pattern explanationnews2011-04-04 22:13
+diplominis?news.omnitel.net2011-04-04 17:45
+Disassembleri rekomenduokit-=Valdas=-2011-04-04 08:03
+Req: Pakeitimų valdymo softas?Begemoc2011-03-31 23:23
+req: foxpro duombaziu redaktorius0.5B2011-03-30 15:28
+Ar yra siame forume developeriu iPad iPhone Apps?LH2011-03-30 00:48
+Klausimas is MS Access VBDonatas2011-03-29 12:20
+ctrl+csdf2011-03-29 11:32
+JAVA class redagavimasJoint_as2011-03-27 12:59
reikia duomenu bazeslwr2011-03-25 21:06
+web'e per lokalu apache nerodo paveikslu@Rimce2011-03-25 10:19
Google maps API ir memory leak'aiSystem2011-03-24 21:59
+php ir wordbertas2011-03-24 21:28
+PHP, versiju controle ir FTP?System2011-03-24 17:46
del appengineNerijus T2011-03-23 13:35
+Kiek toks darbas kainuoja?Sail2011-03-22 11:55
-oracle select uzklausanews2011-03-21 21:48
Re: oracle select uzklausaapchy2011-03-22 11:38
Re: oracle select uzklausanews2011-03-22 11:54
Re: oracle select uzklausa2x502011-03-22 11:59
Re: oracle select uzklausanews2011-03-22 12:09
Re: oracle select uzklausa2x502011-03-22 12:14
Re: oracle select uzklausanews2011-03-22 12:19
Re: oracle select uzklausa@2x502011-03-22 14:03
Re: oracle select uzklausanews2011-03-22 14:35
Re: oracle select uzklausanews2011-03-22 11:56
Re: oracle select uzklausa2x502011-03-22 12:04
Re: oracle select uzklausanews2011-03-22 12:07
Re: oracle select uzklausaLaimis2011-03-21 22:31
Re: oracle select uzklausaalias2011-03-22 00:16
Re: oracle select uzklausanews2011-03-22 10:55
Re: oracle select uzklausaVaidasB2011-03-22 11:03
Re: oracle select uzklausanews2011-03-22 11:12
Re: oracle select uzklausaMaug Lee2011-03-22 11:37
Re: oracle select uzklausanews2011-03-22 11:53
Re: oracle select uzklausaJornada Del Muerto2011-03-31 14:57
Re: oracle select uzklausaLaimis2011-03-22 11:34
Re: oracle select uzklausaMaug Lee2011-03-22 11:40
Re: oracle select uzklausaLaimis2011-03-22 11:47
Re: oracle select uzklausaslavik&dimon2011-03-21 22:23
+OT: Trying to figure out why I have such troubles with programmingzZz2011-03-19 18:35
+Klausimas apie JAVANerijus2011-03-18 11:49
+PastebejimasNerijus2011-03-17 16:37
+Ieskau UI contorlo arba ka patartumet naudot [26kb]@Jornada Del Muerto2011-03-17 13:53
+Q: Del ACTi kameru video streamErnikas2011-03-15 16:33
+C++ namespaceDaynewss2011-03-15 11:00
+Excel kalendorius-kaip?priest2011-03-14 14:59
+MSSQL DB tinkle?bala nemate2011-03-13 14:44
+Delphi ir COM portaiReM2011-03-11 21:19
+integruoti viena weba i kitaLukas2011-03-10 00:45
+RSA sourc'uDarius-B2011-03-09 21:18
+update uzklausa MS SQL serverdz2011-03-09 15:12
+excel specialistamsJurate2011-03-05 16:11
+off: apie interneto perkelimaTrolis2011-03-04 17:09
+haXeJornada Del Muerto2011-03-03 18:44
+ka naudoti web programavimui (dizainui)neklausiu2011-03-02 21:26
JAVA JTable ir row header?System2011-03-02 12:27
+C: masyvo elementu perdavimas funkcijaiKantega2011-02-28 18:33
+excel zinovamsMinVodai2011-02-28 09:16