[es] - Korisne funkcije za racunanje vremena

Zidar
Canada

Član broj: 15387
Poruke: 3085
*.100.46-69.q9.net.

+79 Profil

Korisne funkcije za racunanje vremena

^{16.05.2012. u 20:55 - pre 145 meseci}

NA ovoj adresi http://programmingmaterials.bl...seful-sql-server-datetime.html
ima stos ta korisno za MS SQL.

Code:

—-Today
SELECT GETDATE() ‘Today’
—-Yesterday
SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’
—-First Day of Current Week
SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘First Day of Current Week’
—-Last Day of Current Week
SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘Last Day of Current Week’
—-First Day of Last Week
SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) ‘First Day of Last Week’
—-Last Day of Last Week
SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) ‘Last Day of Last Week’
—-First Day of Current Month
SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) ‘First Day of Current Month’
—-Last Day of Current Month
SELECT DATEADD(ms,- 3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))) ‘Last Day of Current Month’
—-First Day of Last Month
SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)) ‘First Day of Last Month’
—-Last Day of Last Month
SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))) ‘Last Day of Last Month’
—-First Day of Current Year
SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0) ‘First Day of Current Year’
—-Last Day of Current Year
SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0))) ‘Last Day of Current Year’
—-First Day of Last Year
SELECT DATEADD(yy,-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)) ‘First Day of Last Year’
—-Last Day of Last Year
SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))) ‘Last Day of Last Year’

Odgovor na temu

HladankaoLed
Database Consultant
Vienna, Austria

Član broj: 228937
Poruke: 36
*.5.14.univie.teleweb.at.

Sajt: milossql.wordpress.com

+1 Profil

Re: Korisne funkcije za racunanje vremena

^{05.06.2012. u 20:39 - pre 144 meseci}

Da dodamo jos koju...

Code:

--prosli ponedeljak
SELECT DATEADD(day, DATEDIFF(day, '19000101', GETDATE()) /7*7, '19000101');--19000101 ili bilo koji datum za koji je poznato da je (bio) ponedeljak
--prosli utorak
SELECT DATEADD(day, DATEDIFF(day, '19000102', GETDATE()) /7*7, '19000102');
--sledeci ponedeljak
SELECT DATEADD(day, DATEDIFF(day, '19000101', DATEADD(day, -1, GETDATE())) /7*7 + 7, '19000101');

--prvi ponedeljak  u tekucem mesecu
SELECT DATEADD(day, DATEDIFF(day, '19000101', DATEADD(month, DATEDIFF(month, '19000101', GETDATE()), '19000101')-1) /7*7 + 7, '19000101');
--poslednji ponedeljak  u tekucem mesecu
SELECT DATEADD(day, DATEDIFF(day, '19000101',DATEADD(month, DATEDIFF(month, '18991231', GETDATE()), '18991231')) /7*7, '19000101');
--poslednji ponedeljak  u tekucoj godini
SELECT DATEADD(day, DATEDIFF(day, '19000101',DATEADD(year, DATEDIFF(year, '18991231', GETDATE()), '18991231')) /7*7, '19000101');

Sad šta je tu je. A možda će da dođe i ova tvoja tetka iz Bosanske Krupe.

Odgovor na temu