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
*
iNug Technical <4d_tech@lists.4d.com>
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
ecifically trying to query against both date & time.
Steve
-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com]
Sent: Tuesday, July 10, 2018 1:18 PM
To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com>
Subject: RE: SQL Statement Assistance
How abou
There may be multiple things wrong here;
First, is your field actually named TimeStamp?
If so, this is a SQL Reserved word and shouldn’t be used as a field identifier.
Let's start with that first.
-Tim
**
4D Internet Users G
eve
-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com]
Sent: Tuesday, July 10, 2018 1:44 PM
To: s.o...@the-aquila-group.com; '4D iNug Technical' <4d_tech@lists.4d.com>
Subject: RE: SQL Statement Assistance
There may be multiple things wrong here;
First, is your f
ry if fine.
>
> My problem is now trying to make the static timestamp values being queried
> on dynamic.
>
>
> Steve
>
> -Original Message-
> From: Timothy Penner [mailto:tpen...@4d.com]
> Sent: Tuesday, July 10, 2018 1:44 PM
> To: s.o...@the-aquila-group.com;
Steve
Try removing the single quotes in your text variable assignment and retry your
initial example.
Justin
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
That looks like the field is just plain text; have you tried just removing the
extra single quotes from the text variable in your initial example (Justin Will
also suggested this)?
vt_temp1:="04/06/2018 07:58:00 AM"
vt_temp2:="04/06/2018 08:01:00 AM"
Begin SQL
SELECT Recor
ical <4d_tech@lists.4d.com>
Subject: RE: SQL Statement Assistance
Steve
Try removing the single quotes in your text variable assignment and retry your
initial example.
Justin
**
4D Internet Users Group (4D iNUG)
FAQ: http:
*
-Original Message-
From: Timothy Penner [mailto:tpen...@4d.com]
Sent: Tuesday, July 10, 2018 3:09 PM
To: s.o...@the-aquila-group.com; '4D iNug Technical' <4d_tech@lists.4d.com>
Subject: RE: SQL Statement Assistance
That looks like the field is just plai
Original Message-
From: Timothy Penner [mailto:tpen...@4d.com]
Sent: Tuesday, July 10, 2018 1:18 PM
To: s.o...@the-aquila-group.com; 4D iNug Technical <4d_tech@lists.4d.com>
Subject: RE: SQL Statement Assistance
How about?
- Using the TS syntax as described here:
http://kb.4d.com/assetid=
11 matches
Mail list logo