today's date Progress database sql syntax

[weiwei]

I'm creating a report using a report builder tool on progress database, how can I use filter to make the date as today's date?

For example: schooldate=today's date?

Thanks

 

[schaapie]

You mean something like NOW or SYSDATE?

 

[regulatre]

I just used the NOW() function recently and it worked like a charm.

I was adding a record to a table that had a date field defined as "required".

Just off the top of my head my syntax looked something like this:

INSERT INTO PUB.barcode ("UPC","created-date")
VALUES
('40000000001',NOW());
commit

 

[weiwei]

does now() include hours, minutes?

It's good only with date, for that's paramenter when user enter
Thanks

 

[regulatre]

The SQL-92 guide should be able to answer that question and many others.

http://www.progress.com/progress_software/products/documentation/start/docs/sql92/s92/s92.pdf

 

[weiwei]

thanks

Thank you, it's very helpful

 

[ravensensei]

can you point me in right direction at this point to that doc, because I can't find it on the current site.

I'm trying to run a query, but I want everything from yesterday and I can't figure out how to offset NOW()

 

[tamhas]

http://www.psdn.com/library/entry.jspa?externalID=6142&categoryID=2137