<div>
SELECT CHAR(CURRENT_DATE,ISO)<br />
&nbsp; &nbsp; &nbsp; ,CHAR(CURRENT_DATE,USA)<br />
&nbsp; &nbsp; &nbsp; ,CHAR(CURRENT_DATE,EUR)<br />
&nbsp; &nbsp; &nbsp; ,CHAR(CURRENT_DATE,JIS)<br />
FROM SYSIBM.SYSDUMMY1<br />
<br />
---Hope Helpful for you..ISO is your required format I guess.
</div>


SELECT CHAR(CURRENT_DATE,ISO)
      ,CHAR(CURRENT_DATE,USA)
      ,CHAR(CURRENT_DATE,EUR)
      ,CHAR(CURRENT_DATE,JIS)
FROM SYSIBM.SYSDUMMY1

---Hope Helpful for you..ISO is your required format I guess.

<div>
thanks for that - how can i wrap this and create a function for the first date to be returned ?<br />
what would the function be like and how do i call this - i could create another question for this if you want<br />
<br />
thanks
</div>


thanks for that - how can i wrap this and create a function for the first date to be returned ?
what would the function be like and how do i call this - i could create another question for this if you want

thanks

<div>
sorry i'm new to db2 - how do i now run the function from db2 command line
</div>


sorry i'm new to db2 - how do i now run the function from db2 command line

<div>
i will raise another call for this part as i blieve you deserve more points<br />

</div>


i will raise another call for this part as i blieve you deserve more points


<div>
Ok,Fine once you created that I will put the comments for the same.<br />
But its not difficult.<br />
Trust me you will get it in flash :)
</div>


Ok,Fine once you created that I will put the comments for the same.
But its not difficult.
Trust me you will get it in flash :)

<div>
Or best way you can go through the following link..<br />
<a href="http://www.ibm.com/developerworks/data/library/techarticle/adamache/0109adamache.html" rel="ugc">http://www.ibm.com/developerworks/data/library/techarticle/adamache/0109adamache.html</a><br />
<br />
as it will be quite difficult to explain each and everything and it might stop your work for no reason.<br />
<br />
TC
</div>


Or best way you can go through the following link..
http://www.ibm.com/developerworks/data/library/techarticle/adamache/0109adamache.html [http://www.ibm.com/developerworks/data/library/techarticle/adamache/0109adamache.html]

as it will be quite difficult to explain each and everything and it might stop your work for no reason.

TC

<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
I need to write a function which when called will return the current date in the format yyyymmdd<br />
<br />
thanks
</div>
</div>


hi,

I need to write a function which when called will return the current date in the format yyyymmdd

thanks

DB2 need a function to return the return the current date in format yyyymmdd

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.