Converting date to int foramt

Question

0.00/5 (No votes)

See more:

How to convert 2013/12/03 into 20131203

I am using calender control in my C# code and i need to save 'date' format into 'int' in my DB.

If anyone can give me some answers on how to do will be very great full.

Thanks,

Posted 2-Jan-14 1:47am

KRI19

Add a Solution

4 solutions

Solution 1

Use DateTime's Ticks property - its better than 20131203 format as it can be used to reproduce the date without knowledge of how to formatting was done.

Posted 2-Jan-14 1:49am

Kornfeld Eliyahu Peter

Solution 3

Here is how you would get the date as of now into an integer.
I will let you work out the rest, as I don't know the names of variables etc. in your code:

C#

int iso = new int();
int.TryParse(DateTime.Now.ToString("yyyyMMdd"), out iso);

Posted 2-Jan-14 1:56am

GuyThiebaut

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)

Mike Meinz · Accepted Answer · 2014-01-02T01:56:00

It is a best practice to store dates as DATE data type in the database. By storing the date as an integer, you complicate all processing that must be done with the date and increase the chance of programming errors. Please reconsider using INT data type for your date. The DATE data type takes no additional space and provides ease of use and protection from common logic errors.

Karthik_Mahalingam · Accepted Answer · 2014-01-02T01:56:00

C#

string datestr = "2013/12/03";
       // simple way is
       int dateInt = Convert.ToInt32(datestr.Replace("/", ""));

       // ( or )
       // using date object
       DateTime dt = DateTime.ParseExact(datestr, "yyyy/MM/dd", System.Globalization.CultureInfo.InvariantCulture);
       int dateInt2 = Convert.ToInt32(dt.ToString("yyyyMMdd"));

Converting date to int foramt

4 solutions

Solution 4

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0