<div>
Hi,<br />
<br />
What is it that you mean by 'a time files'. Can you be more specific?<br />
<br />
Cheers
</div>


Hi,

What is it that you mean by 'a time files'. Can you be more specific?

Cheers

<div>
Sorry typo:<br />
A db2 database field of type TIME
</div>


Sorry typo:
A db2 database field of type TIME

<div>
Hi mruff,<br />
<br />
What version of DB2 are you running? &nbsp;And what's the underlying server?
</div>


Hi mruff,

What version of DB2 are you running?  And what's the underlying server?

<div>
<div class="content wysiwyg-content">
db2 convert time to string<br />
Hi I want to convert a time files (NOT Date, NOR timestamp) to a string representation with the format: 'HH24MISS'<br />
<br />
I've tried:<br />
1. TO_CHAR(mytime, 'HH24MISS')<br />
2. VARCHAR_FORMAT(mytime, 'HH24MISS')<br />
3. SUBSTR(LPAD(mytime, 6, '0'), 1, 2) ...<br />
<br />
None of it worked<br />
Many thanks for your support
</div>
</div>


db2 convert time to string
Hi I want to convert a time files (NOT Date, NOR timestamp) to a string representation with the format: 'HH24MISS'

I've tried:
1. TO_CHAR(mytime, 'HH24MISS')
2. VARCHAR_FORMAT(mytime, 'HH24MISS')
3. SUBSTR(LPAD(mytime, 6, '0'), 1, 2) ...

None of it worked
Many thanks for your support

db2 convert TIME to string 'HH24MISS'

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.