Very Computer

how to get only DATE without Time?

i use query   select mydate from table

field mydate is DATETIME type and contains i.e 2002-01-01 13:45:34

i need to get only 2002-01-01 - what i have to do?

function DATEPART only gets the one part, i need to get YEARTODAY.
function CONVERT only uses predefined styles, why??? why i can't use like
this  select FORMATDATE('yyyy-mm-dd', mydate) from ....   ???

--
Adams

You can try   select convert(char(10),getdate(),120)

Quote:> how to get only DATE without Time?

> i use query   select mydate from table

> field mydate is DATETIME type and contains i.e 2002-01-01 13:45:34

> i need to get only 2002-01-01 - what i have to do?

> function DATEPART only gets the one part, i need to get YEARTODAY.
> function CONVERT only uses predefined styles, why??? why i can't use like
> this  select FORMATDATE('yyyy-mm-dd', mydate) from ....   ???

> --
> Adams

Which returns a string, not datetime data. Returning datetime data without a time component is
impossible. Either return a string, or set the time portion to 00:00

select CAST(convert(char(10),getdate(),112) AS datetime)

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

Quote:> You can try   select convert(char(10),getdate(),120)

ok, but this could be not compatible, if MS will change behavior in future
releases of sql server

MS should add more function to operate on data types, because now it's wrong
to make low level operations like char(10) substrings

thanks Jaana

Quote:> Adams

Wait for Yukon.  Heard they would have the functionality there.

Adam,

The statement is...

select convert( varchar(10), current_timestamp, 120)

FORMATDATE is not a valid sql server function.

Hope this help,

Rogrio

Quote:> how to get only DATE without Time?

> i use query   select mydate from table

> field mydate is DATETIME type and contains i.e 2002-01-01 13:45:34

> i need to get only 2002-01-01 - what i have to do?

> function DATEPART only gets the one part, i need to get YEARTODAY.
> function CONVERT only uses predefined styles, why??? why i can't use like
> this  select FORMATDATE('yyyy-mm-dd', mydate) from ....   ???

> --
> Adams