Convert getdate() to YYYY/MM/DD?

Is any solution to convert "1055901520" to yyyy/mm/dd:

re: Convert getdate() to YYYY/MM/DD?

Look here.

You will see that [0] is your timestamp (seconds since unix epoch).
However, you should really look at the date() function as this is probably what you are after. To do your request would be:
With the date() function you can put in a second parameter for inital timestamp if that's what you want. If you do not put an initial timestamp, it takes the current one. time() will get you a current timestamp.

I have tried to tell you other ways to solve your problem, but you can use this if that's all you want:

re: Convert getdate() to YYYY/MM/DD?

Thank you

But how can i convert timestamp (seconds since unix epoch) to date?
(Converting a number to date)

re: Convert getdate() to YYYY/MM/DD?

previous post, second paragraph.

re: Convert getdate() to YYYY/MM/DD?

If you read the date() documentation you will see the first parameter is output format ("Y/m/d") and the second is your time stamp (1055901520 or getdate() or blank for current)...