Datetime columns only store dates? (SQL SERVER)

Question

0.00/5 (No votes)

See more:

Hello! I'm using MySQL 2005.
I'm just starting to learn it so I need some help.
Is there a way to store dates only in a datetime column in sql?
When i enter a date, it automatically puts a default time beside it. So i was wondering if there was a way to store dates only.

Posted 12-May-14 19:34pm

charliedev

Add a Solution

Comments

dan!sh 13-May-14 1:41am

Are you using MySQL or MS SQL?

charliedev 13-May-14 2:10am

MS SQL Server

saisrid 13-May-14 1:42am

try this,

In sqlserver for date give datatype as nvarchar(10)

In the code as

DateTime.Now.ToString("dd/MM/yyyy")

phil.o 13-May-14 3:51am

Advising someone to store a datetime as a string? I would vote 1 if I could. Sorry but encouraging bad practices is not the primary goal of this forum.

RahulMGunjal 13-May-14 1:58am

In SQL Server, it stores as datetime only

saisrid 13-May-14 2:07am

I have tried, it worked for me ,plz check the month is given in caps as

DateTime.Now.ToString("dd/MM/yyyy)"

2 solutions

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)

DamithSL · Accepted Answer · 2014-05-12T19:46:00

Solution 1

there is no type called Date in SQL server 2005, you need to use datetime type

check Date and Time Data Types and Functions - SQL Server (2000, 2005, 2008, 2008 R2, 2012)[^]

You can store date as string but it is not recommended, read this[^] and Is it a good practise to store date as stirng?[^]

Posted 12-May-14 19:46pm

DamithSL

Updated 12-May-14 19:57pm

v4

Comments

saisrid 13-May-14 2:05am

The date I have specified is the column name for that we should give datatype as
nvarchar(10).I did not specify the date as a datatype .Plz read the content carefully.

DamithSL 13-May-14 2:09am

what! I haven't answer to your question. what are you talking about?

_Asif_ · Accepted Answer · 2014-05-12T20:09:00

Almost all database store date and time as DateTime. The simplicity in this approach is that it supports both date and time formats. For example if you only want to save the date you simply eliminate the time in the date and store it. For example if you like to store 01-Jun-2014 10:23:14 am you simply truncate it to 01-Jun-2014 00:00:00 am and save it as date time. Additionally if you like to store a date for example 10-Jun-2014 sql server will store it as 10-Jun-2014 00:00:00

Therefore no additional efforts is required to manipulate time. Please Cast and Convert functions for truncation