vladimir omni

vladimir omni

  • NA
  • 3
  • 3.4k

date format yyyy/MM/dd

May 27 2014 2:01 AM
In t-sql i'm using select getdate() function.
it is in yyyy/MM/dd format.

I'm retrieving that date into my UI.

but it is showing this format dd/MM/yyyy

the result is (Conversion failed when converting date and/or time from character string).


how can i change the date format to yyyy/MM/dd.


the coming output = " 27-05-2014 00:18:22 "
My required output = " 2014-05-27 00:18:22"



Thanks In Advance!


Answers (6)