Tim & Anyone Else,
I got it working using the following:
vt_temp1:="2018-04-06 11:09:00 AM"
vt_temp2:="2018-04-06 11:12:00 AM"
Begin SQL
SELECT RecordID, Mach_ID, Energy_1, Energy_2, Energy_3
FROM DMM_TTX_HISTORIAN
WHERE [TimeStamp] >= CONVERT(datetime,CONVERT(varchar(30),:vt_temp1), 101)
AND [TimeStamp] <= CONVERT(datetime,CONVERT(varchar(30),:vt_temp2), 101)
INTO :al_temp1, :at_temp1, :ar_temp1, :ar_temp2, :ar_temp3
End SQL
Hopefully this will assist someone needing to query a timestamp field in SQL.
Steve
-----Original Message-----
From: Timothy Penner [mailto:[email protected]]
Sent: Tuesday, July 10, 2018 1:18 PM
To: [email protected]; 4D iNug Technical <[email protected]>
Subject: RE: SQL Statement Assistance
How about?
- Using the TS syntax as described here:
http://kb.4d.com/assetid=75947
- Using CAST to cast the TEXT as a Timestamp:
http://doc.4d.com/4Dv15/4D/15/CAST.300-2288162.en.html
http://kb.4d.com/assetid=75047
- Using a C_DATE variable instead of a _CTEXT variable
-Tim
Timothy Penner
Senior Technical Services Engineer
4D Inc
95 S. Market Street, Suite #240
San Jose,CA 95113
United States
Telephone: +1-408-557-4600
Fax: +1-408-271-5080
Email: [email protected]
Web: www.4D.com
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
