gopi6417 | SQLServerCentral

gopi6417

Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

RE: change DATE format to DD/MMM/YYYY

I don't know exactly.Could you please tell the syntax on Oracle.

February 25, 2015 at 5:38 am

#1779868
RE: change DATE format to DD/MMM/YYYY

select replace(CONVERT(VARCHAR(11),GETDATE(),106),' ','/')

February 25, 2015 at 5:30 am

#1779861
RE: change DATE format to DD/MMM/YYYY

can you try this.
select replace(CONVERT(VARCHAR(11),GETDATE(),106),' ','/')

February 25, 2015 at 5:25 am

#1779859

Viewing 3 posts - 1 through 3 (of 3 total)