Axapta Code solutions Education and Entertainments Earn Money its Real Experience of knowledge Imortant Weblink collections Fun and Entertainment God thoughts Get Ways to Invest your money Products overview and details
convert date in 'MM/DD/YYYY HH:MI A.M.' format using MS sql
select CONVERT(nvarchar(30), GETDATE(), 101) + ' ' + CONVERT(nvarchar(30), GETDATE(), 114)
format sequence
101 = mm/dd/yyyy
108 = hh:mi:ss
114 = hh:mi:ss:mmm(24h)
convert date in 'MM/DD/YYYY HH:MI A.M.' format using MS sql
select CONVERT(nvarchar(30), GETDATE(), 101) + ' ' + CONVERT(nvarchar(30), GETDATE(), 114)
format sequence
101 = mm/dd/yyyy
108 = hh:mi:ss
114 = hh:mi:ss:mmm(24h)
0 comments:
Post a Comment