| Author |
 Topic  |
|
|
qutesanju
Posting Yak Master
193 Posts |
 Posted - 02/05/2009 : 08:55:44
|
| how to find year end and year start from date entered? |
|
|
Jai Krishna
Constraint Violating Yak Guru
India
333 Posts |
Posted - 02/05/2009 : 09:05:08
|
select dateadd(d,-datepart(dy,getdate())+1,getdate()) as yearstart,
dateadd(d,-datepart(d,getdate()),dateadd(m,13-datepart(m,getdate()),getdate())) as yearend
Jai Krishna |
 |
|
|
Rajesh Jonnalagadda
Starting Member
India
45 Posts |
Posted - 02/05/2009 : 09:37:32
|
Hi,
A small change in Jai krishna yearstart query,
SELECT DateAdd(d, -DatePart(dy,getdate()-1),getdate()) as YearStart,
DateAdd(d, -DatePart(d,getdate()), Dateadd(m,13-datepart(m,getdate()),getdate())) as YearEnd
Rajesh Jonnalagadda
GGK TECH
|
|
|
|
Jai Krishna
Constraint Violating Yak Guru
India
333 Posts |
Posted - 02/05/2009 : 10:04:21
|
quote:
Originally posted by Rajesh Jonnalagadda
Hi,
A small change in Jai krishna yearstart query,
SELECT DateAdd(d, -DatePart(dy,getdate()-1),getdate()) as YearStart,
DateAdd(d, -DatePart(d,getdate()), Dateadd(m,13-datepart(m,getdate()),getdate())) as YearEnd
Rajesh Jonnalagadda
GGK TECH
I think change is not that necessary as my query is producing correct results
Jai Krishna |
|
|
|
jek2201
Starting Member
1 Posts |
Posted - 05/26/2009 : 04:40:44
|
A simple one if you want also to have hours, minuttes and the seconds right as well:
--Year Start
select dateadd(year, (select year(getdate())) - 1900 , '01-01-1900')
--Year End (for some reason -1 wont work and -2 really gives minus 3 but you are into miliseconds)
select dateadd(ms, -2, (select dateadd(year, (select year(getdate())) - 1900 + 1 , '01-01-1900')))
|
|
|
|
bklr
Flowing Fount of Yak Knowledge
India
1693 Posts |
Posted - 05/26/2009 : 04:55:15
|
hai rajesh,
both queries will give u same output
select dateadd(d,-datepart(dy,getdate())+1,getdate()) as yearstart,
dateadd(d,-datepart(d,getdate()),dateadd(m,13-datepart(m,getdate()),getdate())) as yearend
SELECT DateAdd(d, -DatePart(dy,getdate()-1),getdate()) as YearStart,
DateAdd(d, -DatePart(d,getdate()), Dateadd(m,13-datepart(m,getdate()),getdate())) as YearEnd
|
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/26/2009 : 05:11:50
|
Keep it simpleSELECT DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0) AS YearStart,
DATEADD(YEAR, DATEDIFF(YEAR, -1, GETDATE()), -1) AS YearEnd
E 12°55'05.63"
N 56°04'39.26" |
Edited by - SwePeso on 05/26/2009 05:12:01 |
|
|
|
HenryJin
Starting Member
Australia
1 Posts |
Posted - 11/07/2012 : 20:59:49
|
| SwePeso's code is working perfect for me |
|
|
|
madhivanan
Premature Yak Congratulator
India
22461 Posts |
|
| |
Topic |
|
|
|
how to find year end and year start
