Try SYSDATE if your doing this from ODBC, or TODAY if doing this from
4GL.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: 08 August 2008 15:46
To: vantage@yahoogroups.com
Subject: RE: [Vantage] TSQL Help with Progress
So I found that the date function is CURDATE() but that doesn't seem to
be
working. Any ideas
_____
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Charlie Wilson
Sent: Friday, August 08, 2008 8:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] TSQL Help with Progress
I would like to pull the current data in progress to do some comparison
to
time stamps on data in the database but I don't know what the "getdate"
function is for the Progress tsql can some one fill me in on what this
is?
~charlie
[Non-text portions of this message have been removed]
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.0/1601 - Release Date: 8/8/2008
9:02 AM
[Non-text portions of this message have been removed]
4GL.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: 08 August 2008 15:46
To: vantage@yahoogroups.com
Subject: RE: [Vantage] TSQL Help with Progress
So I found that the date function is CURDATE() but that doesn't seem to
be
working. Any ideas
_____
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Charlie Wilson
Sent: Friday, August 08, 2008 8:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] TSQL Help with Progress
I would like to pull the current data in progress to do some comparison
to
time stamps on data in the database but I don't know what the "getdate"
function is for the Progress tsql can some one fill me in on what this
is?
~charlie
[Non-text portions of this message have been removed]
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.6.0/1601 - Release Date: 8/8/2008
9:02 AM
[Non-text portions of this message have been removed]