Hi there!
I want to be able to compare my date field with getdate().
but i keep getting the error message:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
My date field is called 'starttime' and looks like:
13/09/02 11:21:38
getdate() looks like:
2002-11-15 17:02:26.703
I am only interested in the actual date part not the time.
Can someone help me?
Much appreciated
B
I want to be able to compare my date field with getdate().
but i keep getting the error message:
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
My date field is called 'starttime' and looks like:
13/09/02 11:21:38
getdate() looks like:
2002-11-15 17:02:26.703
I am only interested in the actual date part not the time.
Can someone help me?
Much appreciated
B