Click here to Skip to main content
16,012,223 members
Search within:


convert date dd mm yyyy string to datetime in sql server 2005?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
How to convert date dd mm yyyy string to datetime in sql server 2005?
Posted
Add a Solution

1 solution

Hi,

find the query below

SQL
SELECT CONVERT(DATETIME, REPLACE('06 06 2014',' ','/'))


hope this will help you.
 
Share this answer
 
Posted
Comments
Rahul 105 6-Jun-14 2:59am    
I am having date as varchar in dd-mm-yyyy format. Also I ant to add 5 days too the same.
So how can i do this? If its in mm-dd-yyyy format dateadd will work. I want to change dd-mm-yyyy to mm-dd-yyyy format(all varchars)first and then to datetime.
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to convert datetime in the format dd/MM/yyyy hh:mm:ss:tt to yyyy/MM/dd hh:mm:ss tt in ASP.NET with C#?
How I manage system date formate dd/MM/yyyy and MM/dd/yyyy?
How to convert dd/mm/yyyy to mm/dd/yyyy with time (datetime) in sql and then mm/dd/yyyy datetime to dd/mm/yyyy varchar in sql
Convert dd/mm/YYYY to datetime
How to Change Dateformat from DD/MM/YYYY to YYYY/MM/DD
How to get date from server in mm/dd/yyyy format
converting dd/mm/yyyy to mm/dd/yyyy in asp.net
Convert mm/dd/yyyy to dd/mm/yyyy
How to Convert date to MM/dd/yyyy?
How to convert a date string with format “MM dd, yyyy” to yyyy-mmdd

Advertise
Privacy
Cookies
Terms of Use
Last Updated 6 Jun 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-07-22:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900