I have a number as follows: 13901210 I want the output to give the following result 1390/12/10
Input function: a number of bigint Output: a string
How do I create this function?
I wonder why no one suggested this Simple Query
declare @input bigint=13901210
select REPLACE(Convert(varchar,Convert(date,CONVERT(varchar,@input))),'-','/')
SQL Fiddle
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With