Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
COURSE of the MONTH
9 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL 2008 - Convert string to date
Posted on 2013-01-25
Good morning,
I have a number of string fields that represent dates. I would like to convert them to date fields like so:
From: 25-JAN-13
To: 01/25/2013
Thanks in advance for any help.
I have a number of string fields that represent dates. I would like to convert them to date fields like so:
From: 25-JAN-13
To: 01/25/2013
Thanks in advance for any help.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
- +1
5 Comments
Active 1 day ago
http://mobile.experts-exchange.com/Database/Miscellaneous/A_1499-DATE-and-TIME-don't-be-scared-and-do-it-right-the-first-time.html
You will need a double convert, see article
You will need a double convert, see article
SET DATEFORMAT DMY
DECLARE @var NVARCHAR(100)
SET @var = '25-JAN-13'
SELECT CONVERT(varchar, CONVERT(DATETIME, @var, 101), 101)
DECLARE @var NVARCHAR(100)
SET @var = '25-JAN-13'
SELECT CONVERT(varchar, CONVERT(DATETIME, @var, 101), 101)
Active 5 days ago
Thanks for the responses guys.
Angel - I did a brief review of the article you sent. Thank you. I will need to review it again (probably several times) to get it through my thick skull before I try to implement it. :)
Esolve - thanks for your response as well. In your example you use the date from my example (25-JAN-13). I should've been more specific and said I am trying to "batch" convert the dates that are in the format dd-mmm-yy to mm/dd/yyyy (although after reading the article I'm not sure the slash format is what I want to do).
Thanks again for your help and especially the article (teach a man to fish although a fish would taste great right now).
Angel - I did a brief review of the article you sent. Thank you. I will need to review it again (probably several times) to get it through my thick skull before I try to implement it. :)
Esolve - thanks for your response as well. In your example you use the date from my example (25-JAN-13). I should've been more specific and said I am trying to "batch" convert the dates that are in the format dd-mmm-yy to mm/dd/yyyy (although after reading the article I'm not sure the slash format is what I want to do).
Thanks again for your help and especially the article (teach a man to fish although a fish would taste great right now).
Active today
If you're going to store dates in a varchar format, use 'YYYYMMDD'. This format is always interpreted correctly, so you never need any error-prone and time-consuming conversion codes to use it.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Hi all,
It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month9 days, 19 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.