Return date as ddmmyyyy in SQL Server -


i need date ddmmyyyy without spacers.

how can this?

i can yyyymmdd using convert(varchar, [mydatetime], 112)

but need reverse of this.

sql server 2008

convert style 103 dd/mm/yyyy. use replace function eliminate slashes.

select replace(convert(char(10), [mydatetime], 103), '/', '') 

Comments

Popular posts from this blog

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -