Unable to Insert Current Timestamp in DB using C#

Question

I have an SQL command in my code behind as:

cmd = new SqlCommand("insert into MappingInfo(ActivationDate) values (@ActivationDate)", con);

I want to assign 'current timestamp' or 'null' to @ActivationDatebased on some condition, as shown below:

int ActivateState;
if (rdoActivateMappingYes.Checked)
{
    ActivateState = 1;
    cmd.Parameters.AddWithValue("@ActivationDate", "CURRENT_TIMESTAMP");
}
else
{
    ActivateState = 0;
    cmd.Parameters.AddWithValue("@ActivationDate", DBNull.Value);
}

However, upon running the web app, I am getting the following error:

{System.Data.SqlClient.SqlException} : {"Conversion failed when converting date and/or time from character string."}

"CURRENT_TIMESTAMP" is a string, not a DateTime or something. How about using your local time as DateTime.Now or your UTC time (as a better way of course) as DateTime.UtcNow? — Soner Gönül
– Soner Gönül, Commented Dec 9, 2014 at 15:02
@SonerGönül I understood that! Can you please tell me how to enter the current timestamp? What is the correct approach? — Aniruddha Pondhe
– Aniruddha Pondhe, Commented Dec 9, 2014 at 15:04
You would be better served if you defined your datatypes for your parameters instead of forcing the system to figure it out. blogs.msmvps.com/jcoehoorn/blog/2014/05/12/… — Sean Lange
– Sean Lange, Commented Dec 9, 2014 at 15:11

rodrigogq · Accepted Answer · 2014-12-09 15:04:06Z

4

int ActivateState;
if (rdoActivateMappingYes.Checked)
{
    ActivateState = 1;
    cmd.Parameters.AddWithValue("@ActivationDate", DateTime.Now);
}
else
{
    ActivateState = 0;
    cmd.Parameters.AddWithValue("@ActivationDate", DBNull.Value);
}

answered Dec 9, 2014 at 15:04

rodrigogq

1,9531 gold badge16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jauch · Accepted Answer · 2014-12-09 15:02:19Z

3

The message is clear.

The field ActivationDate is a DateTime field, but you are passing a string as value: "CURRENT_TIMESTAMP"

Probably you will have to pass a DateTime value, as DateTime.Now, or any other DateTime that suits the logic of your app/database.

answered Dec 9, 2014 at 15:02

Jauch

1,51810 silver badges19 bronze badges

2 Comments

Aniruddha Pondhe Over a year ago

I understood that! Can you please tell me how to enter the current timestamp? What is the correct approach?

Jauch Over a year ago

@AniruddhaPondhe, use DateTime.Now, or DateTime.UtcNow (mentioned by rodrigoqg)

Tarveen · Accepted Answer · 2014-12-09 15:07:45Z

0

You can use Datetime.parse() method to check if the string is in valid date format.

DateTime date = DateTime.Parse("01/01/1900");

answered Dec 9, 2014 at 15:07

Tarveen

1612 silver badges6 bronze badges

Collectives™ on Stack Overflow

Unable to Insert Current Timestamp in DB using C#

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related