01/01/ and whatever year is coming as current year -1

[sanika1507]

Hi all
how to write this 01/01/ and whatever year is coming as current year -1....in an SQL query .i want it to write it in a stored proc... using SQL server 2000.

Thanks in advance .
.

[iburyak]

Try this :


Select '01/01/' + year(getdate())

[sanika1507]

Try this :


Select '01/01/' + year(getdate())

Thanks a lot for your help but this doesnt work .......like if todays date is 10/09/2007
i want to giv a default date as 01/01/ currentdate -1 ......so tht i get 01/01/2006...Similarly if the current date is 01/01/2008 then also i want 01/01/2007
thnaks in advance

[sanika1507]

Thanks a lot for your help but this doesnt work .......like if todays date is 10/09/2007
i want to giv a default date as 01/01/ currentdate -1 ......so tht i get 01/01/2006...Similarly if the current date is 01/01/2008 then also i want 01/01/2007
thnaks in advance

plus i m gettin the error as


Syntax error converting the varchar value '01/01/' to a column of data type int.

[iburyak]

I assume you want to get a date for one year ago.
select dateadd(yy, -1, getdate())


Originaly i thought you want to get a first day of current year.
Like this:

select '01/01/' + convert(varchar(10), year(getdate()))

Goo Luck.

[Motoma]

I assume you want to get a date for one year ago.
select dateadd(yy, -1, getdate())


Originaly i thought you want to get a first day of current year.
Like this:

select '01/01/' + convert(varchar(10), year(getdate()))

Goo Luck.

I think it would actually be:

SELECT '01/01/' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)
 

[sanika1507]

I think it would actually be:

SELECT '01/01/' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)
 

Thanks to u . So I am gettint he date as I wanted ....now i have declare the

declare @startdate datetime

Set @startdate =' SELECT +''01/01/'' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)'

but now there is an error because of the mismatch datetime and Varchar ,

hence i used again

set convert (varchar(10),@startdate ,101) = ' SELECT +''01/01/'' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)'

but still there is an error.Imean there is a syntax error .Can anyone please correct it ........
Thanks in advance

[Motoma]

Thanks to u . So I am gettint he date as I wanted ....now i have declare the

declare @startdate datetime

Set @startdate =' SELECT +''01/01/'' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)'

but now there is an error because of the mismatch datetime and Varchar ,

hence i used again

set convert (varchar(10),@startdate ,101) = ' SELECT +''01/01/'' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)'

but still there is an error.Imean there is a syntax error .Can anyone please correct it ........
Thanks in advance

The datetime format, when represented as a string looks like this: "2007-10-09 13:18:08.123".
Try "SELECT GETDATE()" to see an example.

[ck9663]

Thanks to u . So I am gettint he date as I wanted ....now i have declare the

declare @startdate datetime

Set @startdate =' SELECT +''01/01/'' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)'

but now there is an error because of the mismatch datetime and Varchar ,

hence i used again

set convert (varchar(10),@startdate ,101) = ' SELECT +''01/01/'' + CONVERT(VARCHAR(10), YEAR(GETDATE()) - 1)'

but still there is an error.Imean there is a syntax error .Can anyone please correct it ........
Thanks in advance

defaulting dates to today's date - 1 year:

select @startdate = dateadd(yy, -1, getdate())


defaulting dates to jan 1 of previous year using "mm/dd/yyyy" format as input

select @startdate = convert(datetime, '01/01/' + cast(year(dateadd(yy, -1, getdate())) as char(4)),101)


these are based on current/system date. replace the "getdate()" string with the fieldname or variable name as necessary.