Date format

[Former Member]

How can I format a date within a query MM/DD/YYYY ?

[former_member206488 · Accepted solution]

Hi,

Try setting in Administrationsystem initializationgeneral setting.

this will change the date format of all date fields of sap.if u want to show for particular form field use below query

SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]

change getdate to your field name and add table name

Thanks,

Neetu

[Former Member · Accepted solution]

Thank you!!

[Former Member]

Hi Marianna.....

What is your date format currently in SAP? Is that DD/MM/YYYY?

if you want it in MM/DD/YYYY

then go to Administration --> System Initialization --> General Settings --> Dosplay Tab and select the date format MM/DD/YYYY.......

Hope this will solve your problem......

Regards,

Rahul

[Former Member]

Can this be done only in the sql query - I don't want to make any changes on the company's system.