how can i split datetime into date ?

Question

0.00/5 (No votes)

See more:

how can i convert

19-jan-12 11:12:12 PM to 19-jan-12

i store datetime in SqlServer Database

it stored as "19-jan-12 11:12:12 PM" format
now i want to get row whose date is 19-jan-12
and bind that data so how can i check from database

please help quickly

thnx

Posted 19-Jan-12 20:59pm

PKriyshnA

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 20-Jan-12 7:02am

You should mention whether you want to do it in code or with query???
The way you asked the question it conveys that you want to do it with SQL Query itself...
You could have commented us that you wanted the coding not query, but giving a poor rating for that is not the wise thing to do....

PKriyshnA 20-Jan-12 9:33am

i have a table named Tbl_Product
having columns (id,PName,PTime)----

(1,Nokia,1/20/2012 7:02:09 PM)
(2,Samsung,1/21/2012 7:02:09 PM)
(3,Micromax,1/20/2012 7:02:09 PM)
(4,Tablet,1/21/2012 7:02:09 PM)
(5,Pendrive,1/20/2012 7:02:09 PM)
now i want to select data in a such manner date shoud be 1/20/2012

compare only 1/20/2012 and bind it to GridView.......help me....

11 solutions

Solution 11

1) string strDate = System.DateTime.Now.ToShortDateString("dd-MM-yy");
2) string strDate = System.DateTime.Now.ToShortDateString();
3) string strTime = System.DateTime.Now.ToShortTimeString();

Posted 20-Jan-12 1:53am

nikheelpatil

Updated 20-Jan-12 1:54am

v2

Solution 10

string.Format("{0:dd-mm-yyyy}", DateTime.Now);

Posted 20-Jan-12 1:05am

Sudip Saha

Solution 8

try this

SELECT CONVERT(VARCHAR(10), getdate(), 105) AS [DD-MM-YYYY]

Posted 20-Jan-12 0:16am

MadhuCodePro

Solution 4

If you want to determine the date part of a SQL datetime value in SQL, the following code is an efficient way to do it:

SQL

print convert(datetime, floor(convert(float, getdate())))

Posted 19-Jan-12 21:41pm

jgegroups

Solution 3

you can use

C#

dateToDisplay.ToShortDateString()

NOTE : The string returned by the ToShortDateString method is culture-sensitive. It reflects the pattern defined by the current culture's DateTimeFormatInfo object. For example, for the en-US culture, the standard short date pattern is "M/d/yyyy"; for the de-DE culture, it is "dd.MM.yyyy"; for the ja-JP culture, it is "yyyy/M/d". The specific format string on a particular computer can also be customized so that it differs from the standard short date format string.

ref : http://msdn.microsoft.com/en-us/library/system.datetime.toshortdatestring.aspx[^]

Posted 19-Jan-12 21:16pm

nrgjack

Solution 1

hello,

please refer
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx
refer this also
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

Posted 19-Jan-12 21:04pm

amolpatil2243

Updated 19-Jan-12 21:10pm

v3

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)

RDBurmon · Accepted Answer · 2012-01-20T02:26:00

SQL

SELECT convert(varchar, getdate(), 100) – mon dd yyyy hh:mmAM (or PM)

                                        – Oct  2 2008 11:01AM

SELECT convert(varchar, getdate(), 101) – mm/dd/yyyy - 10/02/2008

SELECT convert(varchar, getdate(), 102) – yyyy.mm.dd – 2008.10.02

SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy

SELECT convert(varchar, getdate(), 104) – dd.mm.yyyy

SELECT convert(varchar, getdate(), 105) – dd-mm-yyyy

SELECT convert(varchar, getdate(), 106) – dd mon yyyy

SELECT convert(varchar, getdate(), 107) – mon dd, yyyy

SELECT convert(varchar, getdate(), 108) – hh:mm:ss

SELECT convert(varchar, getdate(), 109) – mon dd yyyy hh:mm:ss:mmmAM (or PM)

                                        – Oct  2 2008 11:02:44:013AM

SELECT convert(varchar, getdate(), 110) – mm-dd-yyyy

SELECT convert(varchar, getdate(), 111) – yyyy/mm/dd

SELECT convert(varchar, getdate(), 112) – yyyymmdd

SELECT convert(varchar, getdate(), 113) – dd mon yyyy hh:mm:ss:mmm

                                        – 02 Oct 2008 11:02:07:577

SELECT convert(varchar, getdate(), 114) – hh:mm:ss:mmm(24h)

SELECT convert(varchar, getdate(), 120) – yyyy-mm-dd hh:mm:ss(24h)

SELECT convert(varchar, getdate(), 121) – yyyy-mm-dd hh:mm:ss.mmm

SELECT convert(varchar, getdate(), 126) – yyyy-mm-ddThh:mm:ss.mmm

Prashant Srivastava LKO · Accepted Answer · 2012-01-20T00:29:00

Solution 9

C#

Select Convert(varchar(11),DateofBirth,106)as DateofBirth

Posted 20-Jan-12 0:29am

Prashant Srivastava LKO

Updated 20-Jan-12 3:47am

HarisJayadev · Accepted Answer · 2012-01-19T22:24:00

Solution 7

Use convert function:

When selecting in sql server itself select as like this

"CONVERT(DATE,GETDATE(),101)"

Convert(DataType,Feildname,formattype)

Refer format type in :msdn Link

Posted 19-Jan-12 22:24pm

HarisJayadev

Updated 19-Jan-12 23:41pm

v3

Manoj Kumar Choubey · Accepted Answer · 2012-01-19T21:44:00

Solution 6

TextBox1.Text = DateTime.Now.ToString("dd-MM-yy");

Posted 19-Jan-12 21:44pm

Manoj Kumar Choubey

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2012-01-19T21:44:00

Solution 5

Your required answer is -

select convert(varchar(12), CreatedOn, 106) date from Test