Extract date from datetime field

[creedprg]

Hello Guys

is there any way to extract date from DATETTIME field in SQL sever? In visual foxpro i just issue a command using TTOD(Datetime()) but in MS SQL this TTOD function is not supported, May i know some equivalent command for this function....


Thank you in advance.

 

[imex]

Hi,

Try something like this:

select DATEADD(DAY, DATEDIFF(DAY, 0, DateTimeColumn), 0) as DateTest, -- ...

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imobiliarias-em-guarulhos[/url]

 

[bborissov]

Check CAST and CONVERT() function in BOL.

Borislav Borissov
VFP9 SP2, SQL Server

 

[Olaf Doschke]

Liek Borislav said,

CAST(column as date)
or
CONVERT(date, column)

CAST is ANSI sql standard, CONVERT is T-SQL dialect code. So I'd go for CAST in cases it works and only take CONVERT for the cases CAST is too simple, in this case, CAST works ok.

By the way, you could also CAST(column as time) to get the time portion only, since that is a new* type, too. And to put date and time together use date+CAST(time as datetime)

Bye, Olaf.


*new: it has bneen some years now.

 

[gk53]

use
select convert(varchar(12), getdate(), 101)

just replace getdate() with any datetime value