Q
Problem solve Get help with specific problems with your technologies, process and projects.

Equivalent of Oracle's TO_CHAR function

How can I retrieve the date from SQLServer and convert it to my required format, like I get in Oracle SQL using...

to_char function. In my table, time is in milliseconds, but I don't want the millisecond part in my date resultset.

 

Look up the convert function in Books Online.

For More Information

 

Dig Deeper on Microsoft SQL Server Installation

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close