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

1173

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

Java

How to implement singly linked list in Java

reply views Thread by ravipankaj | last post: by

Software Development

Doubly Linked List In java || Implement DLL Data Structure

reply views Thread by ravipankaj | last post: by

C / C++

Low-invasive C language library

reply views Thread by NPC403 | last post: by

HTML / CSS

How to create an HTML back button

reply views Thread by slotstar | last post: by

Microsoft Access / VBA

Feast Your Eyes On Three MS Access Infographics

5 posts views Thread by isladogs | last post: by

Visual Basic .NET

sub main was not found - solution for complete noobs

reply views Thread by captainhaddock | last post: by

Microsoft Access / VBA

Run Time Error (Type Mismatched)

1 post views Thread by Aftab Ahmad | last post: by

Microsoft Access / VBA

RunSQL no longer recognizes RTRIM()

7 posts views Thread by howard w | last post: by

Microsoft Access / VBA

Show / Hide Fields

1 post views Thread by Prometheus73 | last post: by

Post your reply

Similar topics