Hello, I am new with SQL, and I am quite lost . Please could anyone help me, please?

I have to generate a datetime automatically, to select the start and the end datetime for my query.

I need something like:

@datetime = @day + ' ' + @Month + ' ' + @year + ' 11:00:00'

I have been trying to concatenate them, but it doesn't work.

Regards,
Mushu

What are the data type declarations for your variables?

@day, @Month, etc need to be of type char (or varchar) to concatentate them. The result is of type char. Assuming @datetime is of type datetime, you will need to CAST the resultant character string to a datetime datatype, as:

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hello, thank you for your early answer :D. I have still some problems.

This is my code:

set nocount on
declare @startdate datetime
declare @enddate datetime
declare @day integer
declare @month nvarchar
declare @year integer
declare @daychar nvarchar
declare @yearchar nvarchar
declare @date nvarchar
set @day = day(getdate())
--select day(getdate())
set @month = datename(month, getdate())
--select datename(mm, getdate())
set @year = year(getdate())
--select year(getdate())
set @daychar = cast(@day as nvarchar)
set @yearchar = cast(@year as nvarchar)
set @date = @daychar + ' ' + @month + ' ' + @yearchar
set @startdate = @date + ' 09:00:00'
set @enddate = @date + ' 10:00:00'
set nocount off
-- Result = 1; @month = datename(month, getdate()) = S
-- It looks like I have to define the number of characters, but I don't know,
-- It is a variable
select @date, @daychar + ' ' + @month + ' ' + @yearchar + ' 09:00:00'

What could be te solution?

Thanks, regards,
Mushu

Hello, it's me again, I think I got it :D, this is the code:

set nocount on
--declare @startdate datetime
declare @startdate nvarchar(26)
--declare @enddate datetime
declare @enddate nvarchar(26)
declare @day integer
declare @month nvarchar(9)
declare @year integer
declare @daychar nvarchar(2)
declare @yearchar nvarchar(4)
declare @date nvarchar(17)
set @day = day(getdate())
--select day(getdate())
set @month = datename(month, getdate())
--select datename(mm, getdate())
set @year = year(getdate())
--select year(getdate())
set @daychar = cast(@day as nvarchar)
set @yearchar = cast(@year as nvarchar(4))
set @date = @daychar + ' ' + @month + ' ' + @yearchar
set @startdate = @date + ' 10:00:00'
set @enddate = @date + ' 11:00:00'
set nocount off
-- Result = 1; @month = datename(month, getdate()) = S
-- It looks like I have to define the number of characters, but I don't know it,
-- It is a variable
select top 1 datetime, value, qualitydetail from history
where tagname = 'IS_Feed_Wt_pH'
and datetime >= @startdate
and datetime <= @enddate
order by datetime desc

in this way I get the last value inserted in the interval of time.

Thanks,
Mushu

Hi Mushu,

Why do you have to declare so many such variables?

How about this? It can be done like this too, but I believe this would be a bit slow than the first one. Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Thank you very much happygv, it's just what I need.

I know: keep it simple