[Try to use these formats:

select convert(char(8),getdate(),112) as yyyymmdd

yyyymmdd

--------

20031113

select convert(char(8),getdate(),108) as [hh:mm:ss]

hh:mm:ss

--------

15:11:47

See you

Rubens]

I really need your all expertise!

Current SQL Server store date as DateTime or Small Datetime...

quote:

---

I really need your all expertise!

Current SQL Server store date as DateTime or Small Datetime which Date and Time cannot be separated.

I...