What is the SQL/MP equivalent of CURRENT_DATE?

Question

SQL/MP is an SQL dialect used on proprietary HP NonStop SQL database systems which go back to the 1980ies... (Who has ever worked on a system that is as old as they are, huh? :))

SQL/MP is only somewhat ANSI compliant, for example CURRENT_DATE does not exist. I have however a hard time figuring out what functions do exist that can help me to get the current date in my queries.

Can anyone help me with this dinosaur of an SQL language?

score 1 · Accepted Answer · edited May 30 '19 at 01:47

1

Try CURRENT or CURRENT_TIMESTAMP depending on the context.

The HP NonStop SQL/MP Reference Manual is excellent for this sort of thing - one advantage of using an older product, the documentation is good.

This is the url of HP NonStopSQL/MP Reference Manual you can download it´s a pdf file.

edited May 30 '19 at 01:47

Community

1
1

answered Oct 10 '13 at 09:58

Andy Simpson

367
2
6

Thanks! Took me a while to dig through the 1000 page manual, but `CURRENT YEAR TO DAY` (which is the `CURRENT` command with some params) actually did the trick. – fgysin Oct 10 '13 at 13:55

score 0 · Answer 2 · answered May 29 '19 at 17:25

0

You can use this:

CURRENT YEAR TO DAY

CURRENT is a function that returns the current local date, time, or both. You can find the options of parameters in the HPE NonStopSQL/MP Reference Manual it´s most recent documentation that I know.

answered May 29 '19 at 17:25

oscaraleman.dev

1
1

What is the SQL/MP equivalent of CURRENT_DATE?

2 Answers2