date of format to be DD-MM-YYYY

Question

0.00/5 (No votes)

See more:

i have created a database as follows;

Date of birth datetime(datatype)

in data base store as 1/9/1986 12:00:00

but i want the format 1-sep-1986.

how to do.pleae help me.

Posted 8-Jan-13 17:27pm

Member 8054539

Add a Solution

Comments

[no name] 8-Jan-13 23:37pm

In DataBase it should be saved in "1/9/1986 12:00:00" this format only.

You can't store it in "1-sep-1986" this format.
But in Front End you can display what type you want.There is no chance to store in Backend

6 solutions

Solution 2

In DataBase it should be saved in "1/9/1986 12:00:00" this format only.
You can't store it in "1-sep-1986" this format.
But in Front End you can display what type you want.There is no chance to store in Backend

Posted 8-Jan-13 17:39pm

pranathis012

Solution 4

hi dear,

In Backend, the format stored as per pc Date Format on which database is running.

You Can fatch it as your format from database like---

SQL

select Replace(convert(Nvarchar,getdate(),106),' ','-')

Posted 8-Jan-13 17:52pm

Mr. Mahesh Patel

Solution 5

hey refer below query:

SQL

SELECT     REPLACE(CONVERT(VARCHAR(11), GETDATE(), 106), ' ', '-') AS [DD-Mon-YY]

and also refer below links::
sql-server-2008-date-format[^]

Posted 8-Jan-13 17:53pm

prashant patil 4987

Solution 6

use like this:

C#

DateTime dtDate = Convert.ToDateTime(dataReader["YourDateFieldName"]);
string strFormatedDate = dtDate.ToString("dd-MM-yyyy");

Posted 8-Jan-13 18:25pm

Vishal.Shimpi144

Updated 8-Jan-13 18:36pm

v2

Solution 1

This gets asked daily. Your database is storing a date. The format is just what you see, when you do a select. It's a default, but the data is data, not formatted. You can display it in the way you want in your presentation layer. It is not in any format, in your DB.

Posted 8-Jan-13 17:35pm

Christian Graus

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 · Accepted Answer · 2013-01-08T17:52:00

when a column having datatype date...

1 #

In Open mode Table Records view,(table name -> right clicked -> open)
displaying date's format is depends on System Date format.
Note: for testing change system date format and close & reopen sql server and open table again

2 #

but remember always,
when ever
inserting date
updating date
or comparing date in where condition with date column
use format 'yyyy-MM-dd'

3 #

you can Just display date in format you want, it does not effect table data
for display date in different formats while fetching data using sql query select statement, by default display date is 'yyyy-MM-dd'
in select statement you can choose format using sql functions,
example

SQL

select getdate() as [default]
select convert(varchar(10),getdate(),103) as [dd-MM-yyyy]
select convert(varchar(10),getdate(),101) as [MM-dd-yyyy]
select convert(varchar(10),getdate(),102) as [yyyy-MM-dd]

for more date formats...
http://www.sql-server-helper.com/tips/date-formats.aspx
http://msdn.microsoft.com/en-us/library/ms189491.aspx[^]

so, answer of your question is you can not store date in a format you desire<br />
but you can display it in different format

Happy Coding!
:)