Get Current date in SQLBase

Question

I have an SQLBase and I am trying to get the current date of the system to be equal to the date of a column (create_date).

The MySQL Code will be:

Select * From Date D
Where D.Create_date=CURDATE();

Can someone suggest me a way to take the current date in a SQLBase?

The date format should only contain the date(yyyy-MM-dd) and not the timestamp.

I know this has already been answered , but if you need to know more about SQLBase, here is a link to some manuals for every version from v8 thru v12.1 : http://samples.tdcommunity.net/index.php?dir=SqlBase/SqlBase_Books/ — Steve Leighton, Jul 20 '18 at 01:50

score 3 · Accepted Answer · answered Dec 08 '17 at 21:58

3

To get the current date, and not time, you should be able to use @DATEVALUE(@NOW).

answered Dec 08 '17 at 21:58

digital.aaron

5,435
2
24
43

Thanks for your response. Should I use the command like: where d.create_date=@DATEVALUE(@NOW)? – Mike M. Kaspin Dec 08 '17 at 22:03
Unfortunately, I will try it later this week.If it works I will accept it! Thanks again – Mike M. Kaspin Dec 08 '17 at 22:33

score -2 · Answer 2 · answered Dec 08 '17 at 21:52

-2

This should get you the results you want:

DECLARE @Temp TABLE (
Col1 NVARCHAR(1)
,Date  date 
)

INSERT INTO @Temp
VALUES 
('a','2017-12-08')
,('b','2017-12-08')


SELECT *
FROM @Temp
WHERE Date = CONVERT(date, getdate())

answered Dec 08 '17 at 21:52

UpdateName

1

1

getdate() isn't a valid function in SQLBase – digital.aaron Dec 08 '17 at 21:56
This looks more like SQLServer - its def not SQLBase. No CONVERT, no DECLARE, no getdate() – Steve Leighton Jul 18 '18 at 21:56

Get Current date in SQLBase

2 Answers2