how to convert int type to date type in a table

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

I have table which store the date in yyyymmdd and it is a integer field i want to convert it to mm-dd-yyyy format.can any one help me???

Posted 10-Mar-14 3:14am

Sandip Paul 491984

Add a Solution

Comments

Maarten Kools 10-Mar-14 9:22am

Why is a date stored as an integer? Why wasn't a DATETIME[^] data type used instead?

Anyway, convert the integer to a string and then retrieve the appropriate substrings to format it in the proper way.

Sandip Paul 491984 10-Mar-14 9:26am

actually i got a project in which i have to change the existing data to new format.The old data have the data format as yyyymmdd format and i need to change it to mm-dd-yyyy before redesign the application

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Aarti Meswania · Answer 1 · 2014-03-10T03:31:00

Solution 1

SQL

DECLARE @intDatetime int = 20140327
DECLARE @strDatetime VARCHAR(10) = convert(varchar(10),@intDatetime)
SELECT 'Date time in MM/dd/yyyy Format' = convert(VARCHAR(10),convert(datetime,@strDatetime),101)

Happy Coding!
:)

Posted 10-Mar-14 3:31am

Aarti Meswania