Hi all

Apologies for what appears to be a repeat of previous postings but I
can't seem to get this to work.

I have a date column containing a 29 digit date -
2003-12-05-12.00.00.000000000
I want to use a single SQL select to retrieve this column in the
format 2003-12-05.

I have tried using SUBSTRING to do this but seem to always get NULL
returned.

Help much appreciated!!!

Thanks
Gary

Hi.

Try something like
select substring(convert(char(10), getdate(), 102),1,4) + '-' +
substring(convert(char(10), getdate(), 102),6,2) + '-' +
substring(convert(char(10), getdate(), 102),9,2) + '-' +





"Gary Johnson" <gc.johnson (AT) virgin (DOT) net> wrote

In article <4e6f1307.0312041945.63a00f66 (AT) posting (DOT) google.com>, Gary Johnson wrote:
select str_replace(convert(varchar(12),ur_column,111),'/','-') from
ur_table


--
___ _

Rene van Leeuwen <r.t.j.van.leeuwenNOSPAM (AT) THANKSplanet (DOT) nl> wrote

And if you are working IQ 12.5 use:
select dateformat(getdate(),'yyyy-mm-dd')


--Patti