> DECLARE @Year int
> DECLARE @Month int
> DECLARE @Day int
>
> SET @Year = 2005
> SET @Month = 02
> SET @Day = 27
>
> SELECT
> CAST(
> CAST(@Year AS char(4))
> +RIGHT('0' + CAST(@Month AS varchar(2)), 2)
> +RIGHT('0' + CAST(@Day AS varchar(2)), 2)
> AS datetime)
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> <aroraamit81@gmail.com> wrote in message
> news:1132746277.481717.168850@g49g2000cwa.googlegroups.com...
>>I have three date parts namely,
>>
>> Year
>> Month
>> Date/Day
>>
>> as integer values stored in one column each in a table in a SQL Server
>> 2000 database. I need a function to serialize/compose/create a datetime
>> type out of them so I could use that in a query (pseudosyntax) as
>> below:
>>
>>
>> SELECT CreateDate(iYear, iMonth, iDay) As TheDateIWant FROM ThatTable
>>
>>
>> and then later on, I probably want to use an aggregation/computation on
>> that like, the MAX function, may be:
>>
>>
>> SELECT MAX(CreateDate(iYear, iMonth, iDay)) As TheDateIWant FROM
>> ThatTable
>>
>>
>> Thanks!
>>
>
>

> DECLARE @Year int
> DECLARE @Month int
> DECLARE @Day int
>
> SET @Year = 2005
> SET @Month = 02
> SET @Day = 27
>
> SELECT
> CAST(
> CAST(@Year AS char(4))
> +RIGHT('0' + CAST(@Month AS varchar(2)), 2)
> +RIGHT('0' + CAST(@Day AS varchar(2)), 2)
> AS datetime)
>

<aroraamit81@gmail.com> wrote in message
news:1132746277.481717.168850@g49g2000cwa.googlegroups.com...
>I have three date parts namely,
>
> Year
> Month
> Date/Day
>
> as integer values stored in one column each in a table in a SQL Server
> 2000 database. I need a function to serialize/compose/create a datetime
> type out of them so I could use that in a query (pseudosyntax) as
> below:
>
>
> SELECT CreateDate(iYear, iMonth, iDay) As TheDateIWant FROM ThatTable
>
>
> and then later on, I probably want to use an aggregation/computation on
> that like, the MAX function, may be:
>
>
> SELECT MAX(CreateDate(iYear, iMonth, iDay)) As TheDateIWant FROM
> ThatTable
>
>
> Thanks!
>