Hi all,

I am following the same way what you are suggesting now.

Ex : select convert(varchar(30),getdate(),121)

But the important for me is storing rather than fetching the data.

Any other ways??

Cheers!

Sandy.