# Date function

**URL:** <https://techcommunity.softwareag.com/t/date-function/101702>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Basics-on-Mainframes\
**Created:** [November 6, 2012, 2:18pm UTC](https://techcommunity.softwareag.com/t/date-function/101702 "2012-11-06T14:18:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bev\_F](https://avatars.discourse-cdn.com/v4/letter/b/e36b37/32.png) [@Bev\_F](https://techcommunity.softwareag.com/u/Bev_F)\
**Post date:** [November 6, 2012, 2:18pm UTC](https://techcommunity.softwareag.com/t/date-function/101702/1 "2012-11-06T14:18:37Z")

</div>

I want my system date of the DB (adabas). There were no information on google.

Something like in other DB:

SELECT SYSDATE FROM dual;

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [November 6, 2012, 2:29pm UTC](https://techcommunity.softwareag.com/t/date-function/101702/2 "2012-11-06T14:29:10Z")

</div>

There is no such thing.

What would you need it for ?

---

<div class="post-metadata">

**Author:** ![Brian\_Johnson1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/brian_johnson1/32/163_2.png) [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\
**Post date:** [November 21, 2012, 9:59pm UTC](https://techcommunity.softwareag.com/t/date-function/101702/3 "2012-11-21T21:59:38Z")

</div>

You could always use Natural if you want to know the system date:

DISPLAY \*DATX (EM=YYYY-MM-DD)

ADABAS SQL Gateway can’t even help here because there is no “dual” object in ADABAS, but as you see there are always ways to interrogate the system date. :lol:

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:02pm UTC](https://techcommunity.softwareag.com/t/date-function/101702/4 "2021-04-02T15:02:33Z")

</div>