How To insert blank data in sql Table

Question

0.00/5 (No votes)

See more:

I have a Table

SQL

Create Table #Temp(CrtDt Datetime)

and i want to insert some blank value into that table i am trying like this

SQL

insert into #Temp values('')

But i am getting data in into my Table

CrtDt
1900-01-01 00:00:00

Can any one Help me to insert blank data in my table if it is possible.

Posted 9-Apr-13 5:35am

Susheel Kumar Verma

Add a Solution

Comments

Richard C Bishop 9-Apr-13 11:38am

Try inserting "NULL".

2 solutions

Solution 2

Additional information about DateTime datatype you can find here: http://technet.microsoft.com/en-us/library/ms187819.aspx[^]

Posted 9-Apr-13 6:11am

Maciej Los

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)

OriginalGriff · Accepted Answer · 2013-04-09T05:42:00

Solution 1

Change your table definition to be clearer:

SQL

Collapse | Copy Code
Create Table #Temp(CrtDt Datetime NULL)

(It defaults to a nullable field but it's a little more obvious) then just insert a null value:

SQL

INSERT INTO #Temp (CrtDt) VALUES(null)

Posted 9-Apr-13 5:42am

OriginalGriff

Comments

[no name] 9-Apr-13 11:52am

Due to some validation Region i do not null values i want either correct Datetime value or blank value

Maciej Los 9-Apr-13 11:59am

You can always treat 1900-01-01 00:00:00 as a blank value ;)

OriginalGriff 9-Apr-13 12:13pm

Your choices are simple: null or a valid dateTime. Personally, I would use a null, or the minimum dtaatime value (with for s DATETIME column is 1753-01-01 @ 00:00:00.000, for a DATETIME2 it is 0001-01-01 @ 00:00:00.000.
If you supply a blank or zero value, there is an implicit cast to Jan 1st 1900, which means it is probably a bad value to use.

I would use a null if I meant "this field has no value set".

Maciej Los 9-Apr-13 11:58am

+5

[no name] 9-Apr-13 12:03pm

That mean i can not insert blank value in column which data type is DateTine

Maciej Los 9-Apr-13 12:07pm

Yes, it does mean you can't store blank value if datatype is DateTime.

[no name] 9-Apr-13 12:08pm

Thank You so much.

Maciej Los 9-Apr-13 12:12pm

You're welcome ;)

Maciej Los 9-Apr-13 12:18pm

Please, mark this question as "solved" (green button) and vote-up each valueable answer.