Forums | Help | Site Map

Join Bytes
Login

network: 226,501 (1479 online)

bytes

date time to date only

kkshansid is offline

Familiar Sight

Join Date: Oct 2008

Posts: 128

#1: Oct 27 '08

Quote:

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

ck9663 is offline

Expert

Join Date: Jun 2007

Posts: 1,925

#2: Oct 27 '08

re: date time to date only

Use CONVERT() function.

Happy Coding!

-- CK

Reply

« previous question | next question »

Similar Microsoft SQL Server bytes

Overriding a Date/Time stamp, and then Resetting it (answers)
Adding Date/Time to an HTML form? - Request_Information_b.html (0/1) (answers)
export to tab-delimited file adds to time to date field (answers)
Binding ListBox to Date Only (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,501 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved