How to convert SQL Server s timestamp column to datetime format

0 votes

Is there a simple way to convert a string to date format like "Y-m-d H:i:s" since SQL Server delivers timestamps like "Nov 14 2011 03:12:12:947PM".

I have used:

date('Y-m-d H:i:s',strtotime('Nov 14 2011 03:12:12:947PM'))

Can someone please help me in solving this?

Aug 21, 2022 in Database by Kithuzzz
 • 38,020 points • 1,579 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers

How to get Time from DateTime format in SQL?

I want to use a SQL query ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,020 points • 885 views
0 votes
0 answers

How to convert date into timestamp in SQL query?

I'm attempting to move data from the ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
 • 38,020 points • 1,649 views
0 votes
1 answer

How to format datetime in SQL SERVER

In SQL Server 2012 and up you ...READ MORE

answered Sep 18, 2022 in Database by narikkadan
 • 63,680 points • 902 views
0 votes
1 answer

How to rename a column in a database table using SQL?

For SQL Server, use sp_rename USE AdventureWorks; GO EXEC sp_rename 'Customers.CustomerTerritory.TerritoryID', ...READ MORE

answered Feb 9, 2022 in Database by Neha
 • 9,020 points • 738 views
0 votes
0 answers

How to change column datatype in SQL database without losing data?

I have a SQL Server database, and ...READ MORE

Feb 25, 2022 in Database by Vaani
 • 7,070 points • 691 views
0 votes
1 answer

How to convert a column number (e.g. 127) into an Excel column (e.g. AA)

If anyone needs to do this in ...READ MORE

answered Mar 30, 2022 in Database by gaurav
 • 23,260 points • 1,001 views
0 votes
1 answer

How Can I use "Date" Datatype in sql server?

There's problem in all of them and ...READ MORE

answered Feb 9, 2022 in Database by Neha
 • 9,020 points • 1,327 views
0 votes
1 answer

Difference between datetime and timestamp in sqlserver?

Timestamp is a synonym for rowversion, according ...READ MORE

answered Feb 16, 2022 in Database by Vaani
 • 7,070 points • 4,864 views
0 votes
1 answer

How to convert DateTime to VarChar

With Microsoft Sql Server: -- -- Create test case -- DECLARE ...READ MORE

answered Feb 23, 2022 in Database by Neha
 • 9,020 points • 1,165 views
0 votes
1 answer

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

 I ran into the same problem due ...READ MORE

answered Feb 23, 2022 in Others by Aditya
 • 7,680 points • 10,877 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.