date time to date only

kkshansid

232 100+

how to convert my fiield project date which is giving date and time both to give only date

my query is
select [project date] from project
it gives
project date

2003-05-08 00:00:00
i want
2003-05-08
format

Oct 27 '08 #1

Follow Post Reply

1204

ck9663

2,878

Expert 2GB

Use CONVERT() function.

Happy Coding!

-- CK

Oct 27 '08 #2

Similar topics

ASP / Active Server Pages

Week calculations (Date/Time)

2 posts views Thread by androtech | last post: by

Javascript

Date Bug??? Need help:-)

8 posts views Thread by Shlomi Schwartz | last post: by

Microsoft SQL Server

querying by date on smalldatetime

7 posts views Thread by Marc Pelletier | last post: by

Microsoft Access / VBA

Separating data by date

2 posts views Thread by Riegn Man | last post: by

C# / C Sharp

Date ONLY data type.

1 post views Thread by ESPNSTI | last post: by

Visual Basic .NET

Inserting Date or Time into Sql Server Using SQLcommand

15 posts views Thread by Khurram | last post: by

Javascript

UTC date and time to local

13 posts views Thread by maflatoun | last post: by

ASP.NET

Pulling from Access Query, Cannot Change Date/Time Formats

3 posts views Thread by Jim in Arizona | last post: by

Microsoft Access / VBA

separate date with time

3 posts views Thread by colleen1980 | last post: by

Javascript

Check if one date is later then first date

44 posts views Thread by user | last post: by

General

One-click trial on TYK API gateway with Tin

reply views Thread by Trystan | last post: by

General

lancet (util function library of go) released v2.0.0, fully supports go generic features

reply views Thread by lanliddd | last post: by

Microsoft Excel

A tool which can batch import multiple excel files into mysql/oracle database automatically

reply views Thread by ryjfgjl | last post: by

Ruby / Ruby on Rails

Sending & Testing Emails with Ruby

reply views Thread by AlexandraMT | last post: by

MySQL Database

Programming

1 post views Thread by livre | last post: by

C# / C Sharp

[Error] invalid operands of types 'double' and 'double' to binary 'operator%'

1 post views Thread by Stoney L | last post: by

C# / C Sharp

Operation not allowed on non-connected sockets

reply views Thread by Domgrar | last post: by

General

Is there a Time Standard in programming that actually goes down?

reply views Thread by drunkenHiker | last post: by

Javascript

How to get the correct js content?

1 post views Thread by markleo | last post: by

Post your reply

Similar topics