Hi Pankaj
Ok, I tried your suggestion and now I am not getting the error message, but no data is returned? Is this not a case of converting this field (which is a integer, to a string and then cast it as a datetime format?). If so, can you maybe help with the syntax of such a query? ALso can I do it from a view, where I am running this from, as I am also not sure where to enter it in the view?. Hope you can help.
Cheers,...
Riaan
Last Activity: Aug 16 '06, 09:07 PM
Joined: Aug 2 '06
Location:
-
Hi Pankaj
Ok, I tried your suggestion and now I am not getting the error message, but no data is returned? Is this not a case of converting this field (which is a integer, to a string and then cast it as a datetime format?). If so, can you maybe help with the syntax of such a query? ALso can I do it from a view, where I am running this from, as I am also not sure where to enter it in the view?. Hope you can help.
Cheers,...Leave a comment:
-
Hi Phil. Ok I treid your suggestion, but get the following error "Syntax error converting datetime from character string.". Any more ideas :).
Cheers, Riaan.Leave a comment:
-
Hi There.
Ok, I have tried your suggestion, but get the following error:
"Syntax error converting datetime from character string."
Any further ideas :). Cheers, Riaan.Leave a comment:
-
Previous day query
Hi There,
I am a newbie on SQL qieries and I am trying to run a query on a date/time filed to get yesterdays data.
Here is my test query ran from SQL analyzer:
select * from mvs_store_all_d ata_time_change where mvs_creation_da te = {fn NOW() }
The error I am getting is:
Server: Msg 241, Level 16, State 1, Line 1
Syntax error converting datetime from character string.... -
Trying to run SQL Date query
Hi There,
I am a newby with SQL and I am trying to run a query on a date/time field. The query is for the previous date. I would like to create this as a criteria in a view, but not sure what the criteria should look like doing a previous day query.
The test query I have done using SQL analyzer is (select * from mvs_store_all_d ata_time_change where mvs_creation_da te like '060801%').
This returns the previous...
No activity results to display
Leave a comment: