How to convert the date format from MM/DD/YYYY to MM.DD.YY

[Former Member]

Hi Expert

How to write the query convert the date format from  MM/DD/YYYY to MM.DD.YY

Please help

[former_member349215]

Hi Vern,

CONVERT(VARCHAR(10),GETDATE(),4)

Kind Regards,

Pascale

[former_member384109]

Hi vern,

Where you want to change this data format.

Like in which system and where exactly.

Regards,

Ankit

[alain_arnado2]

Hi Vern,

Just to let you know, that when you create a query with dates in SAP, the system will show you the date format according to the General Settings you setup.

So if the date separator is set to "." then your dates will show mm.dd.yyyy in the query results.

Hope this helps.

ALAIN