How to assign OR get Time value to a colum

How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ?)

Happy Coding

hi,

there's no other function aside form getdate().

if you want it to be stored automatically to a column you have to enforce a "default constraint"

thanks,

joey

|||

MasterG wrote:

How can i store time value in a column. And also i need to compare the values. Another problem is , how can i get the Current time of the server.(something like getdate() ?)

Happy Coding

Hi,

Please see answer; http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1000324&SiteID=1

Most people wont like you double posting a question here, but it looks like your new so I guess everyone will let you off, just the once

Happy Coding!

hth
Pace|||

What a shame but sorry for duplicate post. But it is caused from my web browser. Sorry for that , and also thanks for your solution.

Very Happy Coding now ha .....