Date time - datatypes 1

[nread]

Hi all,

Does anyone know if there is a simple way to select from a datetime field, something similar to that of TRUNC in Oracle...

I'm fairly new to SQL Server and seem to being having an absoloute nightmare with dates....!!

Any suggestions welcome....

Cheers

 

[ClaireHCM]

Can you be more specific.Please give some example about your desired result.

 

[mit99mh]

Do you mean trim certain fields off?
This trims 1st to 17th character date in UK format.

SUBSTRING(CONVERT(VarChar, dateTimeField, 113), 1, 17) AS 'someDate',

Try Programs -> SQL Server -> Books Online

SUBSTRING
CAST
CONVERT
Hope this helps a bit

 

[SQLBill]

You don't even need the substring command:

convert(varchar(17), getdate(), 113) does the same thing as mit99mh's suggestion.

-SQLBill

 

[mit99mh]

Cheers for that Bill - its way better than my suggestion

 

[nread]

Cheers all, I needed to set the time to be 00:00:00 using
CAST(FLOOR(CAST(dtmDate AS FLOAT)) AS DATETIME).

I am now using Bills suggestion, thanks Bill....