Search results for query: *

Defined timestring as char(26).. In both queries I am accessing same data with from , to time stamps. Let's say example accessing data from 1/07/2021 8:00:00 to 2/7/2021 8:00:00. If I split the time stamp in two parts 1/7)2021 8:00:00 to 1/7/2021 23:00:00 and 2/7/2021 00:00:00 to 2/7/2021...

Hello Andrz have a look at this i wannna know how the search is working with this to queries.. Have a look at attachments. https://files.engineering.com/getfile.aspx?folder=cdb0fc09-1010-48f4-ae7c-9cbc748deed7&file=sql_search_query.png

Hai @Andrz I tried of converting my data type from char to datatime datatype. but it results in error showing a message - Unable to modify table. The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. The statement has been terminated.

Gud Mng, My column "TimeString" is of char(26) datatype.. ho to workout from this.. here is my attachment https://files.engineering.com/getfile.aspx?folder=5ab1026b-422c-4440-8802-078f91e9ef2b&file=Capture.PNG

Hello all., Hope all dng gud.. I have a application where I will log my data in ms SQL every one hour.. So for reporting purpose I will fetch data from db, based on time stamps. Let's say I want to fetch data in between 12-07-2021 8:00:00 to 13-07-2021 8:00:00 (i.e 24 hrs data) So for this...

hankyou Andrzejek I got it.actually I has to take recordset.eof I modified it now it's okay.. So now my next task is to select records based on time string.. For suppose let's say I am logging my data for every 5Min.. So from an third party interface I will give start time and end time...

thankyou #Andrzejek, Hello members, ya i got it where i went wrong. so right now i have established connection with my recordset and able to write read data. my next task is , i want to fetch some data , and write it to excel which i have done partly.. so as per my code i am reading data...

Good Evening Members, Here i want to access data from Database using VBScript, so regarding that i have gone through some of the examples ,but none of them working in my case. My DB name Dummy ODBC Data Source connection DDSN Logging in to db using windows authantication. Some how by seeing...