I connect to Azure SQL database form Local SSMS. please find the below points. I have a table(CL_ClientEmployee) with column Birthon(datatype is datatype) in Azure SQL when I run the below query, data is coming wrong Why? I required the below outputfor the given input values in Birthon Column of CL_ClientEmployee table. Could you please give me the query? ExampleA) input 1900-01-01(value in BirthOn column) output 01/01 (Month/Date) ExampleB) input 1900-12-01(value in BirthOn column) output 12/01 (Month/Date)

Please try the following: SELECT CONVERT(VARCHAR(5), BirthOn,101) AS [MM/DD] FROM CL_ClientEmployee

required concatenated string of month and day with trailing zeros in Azure SQL

Tangirala DineshReddy 21

I connect to Azure SQL database form Local SSMS.

please find the below points.

I have a table(CL_ClientEmployee) with column Birthon(datatype is datatype) in Azure SQL
1. when I run the below query, data is coming wrong Why?

I required the below outputfor the given input values in Birthon Column of CL_ClientEmployee table. Could you please give me the query?

ExampleA)
input
1900-01-01(value in BirthOn column)
output
01/01
(Month/Date)

ExampleB)
input
1900-12-01(value in BirthOn column)
output
12/01
(Month/Date)

Anurag Sharma 17,606 Reputation points

2021-06-08T05:29:10.977+00:00
Hi @Tangirala DineshReddy , welcome to Microsoft Q&A forum.

The query mentioned by you looks fine to me. I ran below statements and was able to get the desired result:

create table CL_clientEmployee(BirthOn datetime) insert into CL_clientEmployee values ('1900-01-01') insert into CL_clientEmployee values ('1900-12-01') select distinct BirthOn,MONTH(BirthOn) MonthofBirthOn, day(BirthOn) DayOfBirthOn, concat(MONTH(BirthOn),'/',day(BirthOn)) Month_date_concat from CL_clientEmployee

Would it be possible for you to share the create script of table and also few records, so I can try repro the issue from my side?
Tangirala DineshReddy 21 Reputation points

2021-06-08T12:30:54.197+00:00

Hi Anurag,

Thanks for your reply. I will share it by end of day.
Anurag Sharma 17,606 Reputation points

2021-06-14T12:16:34.04+00:00

Hi @Tangirala DineshReddy , just following up on the same.
Tangirala DineshReddy 21 Reputation points

2021-07-06T16:56:15.803+00:00

Please find the attachment of script.112285-cl-cleintemployee.txt

Could you please suggest by tomorrow morning