Need to know about Getdate function?

23 Jun 2006 11:33 AM

SouRa

Hai,

Let me know when this function returns null value

Substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+'
'+right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4)

regards
Soura

23 Jun 2006 1:00 PM

Aaron Bertrand [SQL Server MVP]

> Let me know when this function returns null value

I can't think of a situation. Are you getting a NULL value? Can you
provide a repro?

Show quote

>
> Substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+'
> '+right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4)
>
> regards
> Soura
>
>

23 Jun 2006 1:05 PM

Tracy McKibben

SouRa wrote:

> Hai,
>
> Let me know when this function returns null value
>
> Substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+'
> '+right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4)
>
> regards
> Soura
>
>

That should never result in a NULL value.

23 Jun 2006 1:20 PM

Michael Epprecht [MSFT]

Hi

select substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+ ' ' +
right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4)
--------
Jul 2006
(1 row(s) affected)

Regards

--
Mike

This posting is provided "AS IS" with no warranties, and confers no rights.

Show quote

"Tracy McKibben" <tr***@realsqlguy.com> wrote in message
news:ePUGCXslGHA.3468@TK2MSFTNGP03.phx.gbl...
> SouRa wrote:
>> Hai,
>>
>> Let me know when this function returns null value
>>
>> Substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+'
>> '+right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4) regards
>> Soura
>>
>>
> That should never result in a NULL value.

23 Jun 2006 1:31 PM

SQL Menace

Unless you do something crazy like this

declare @space varchar(20)

select substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+
@space +
right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4)

instead of this

declare @space varchar(20)
select @space =' '
select substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+
@space +
right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4)

But that is the only way I can think of

Denis the SQL Menace
http://sqlservercode.blogspot.com/

SouRa wrote:
Show quote

> Hai,
>
> Let me know when this function returns null value
>
> Substring(Convert(varchar,DateAdd(MM,1,GETDATE()),107),1,3)+'
> '+right(Convert(varchar,DateAdd(MM,1,GETDATE()),107),4)
>
> regards
> Soura

23 Jun 2006 2:58 PM

Omnibuzz

May be your server's system clock is showing date before 1753
and your ansi_warnings setting is ON :)

--
-Omnibuzz (The SQL GC)

http://omnibuzz-sql.blogspot.com/