Ask - Convert Date format YYYYY-MM-DD HH:MM:SS.MMM to MM/DD/YYYY HH:MM:SS

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

Convert Date format YYYYY-MM-DD HH:MM:SS.MMM to MM/DD/YYYY HH:MM:SS

Apr 2 2012 12:00AM by Pavan

How to Convert this date format YYYYY-MM-DD HH:MM:SS.MMM(2012-04-02 02:04:36.443) to MM/DD/YYYY HH:MM:SS(04/02/2012 02:04:36) this date format?

Thanks

Pavan

Submitted under: Microsoft SQL Server · TSQL · · ·

Pavan

212 · 1% · 219

1 Replies

Hi Pavan, What is the destination to which you are sending the formatted date? If it is to a DB the format will have no effect, and when you retrieve the data from the db you would have to apply format as you want.

commented on Apr 3 2012 12:45AM

Sudeep Raj

12 · 13% · 4287

Your Reply

Sign Up or Login to post a comment.