I have a problem in SQL Server using from VB6.
My problem is in the datetime fields when I try to compare a 'Date and Time' that match with the value of the field.
When I save a Date field with the Getdate() function of SQL SERVER and later I try to compare this field with another date, using the Getdate() function of VB6, the query doesn´t find anything, however if I write the field by hand, and exactly equal that this is with the Getdate(), the query find it...
There is any way to Compare the 'date' and the 'time' together or I have to use the function convert to compare the 'date' part of the field only, and then use another time the function convert to compare the 'time' part of the field?.
Aren´t the Gettime() of VB6 and SQL equals?
where is the different?
I don´t know if you understand me. My english is very bad...
I´m spanish.
Thanks in advance
My problem is in the datetime fields when I try to compare a 'Date and Time' that match with the value of the field.
When I save a Date field with the Getdate() function of SQL SERVER and later I try to compare this field with another date, using the Getdate() function of VB6, the query doesn´t find anything, however if I write the field by hand, and exactly equal that this is with the Getdate(), the query find it...
There is any way to Compare the 'date' and the 'time' together or I have to use the function convert to compare the 'date' part of the field only, and then use another time the function convert to compare the 'time' part of the field?.
Aren´t the Gettime() of VB6 and SQL equals?
where is the different?
I don´t know if you understand me. My english is very bad...
I´m spanish.
Thanks in advance