# How to convert char to date or time type?

**URL:** <https://forum.kx.com/t/how-to-convert-char-to-date-or-time-type/10319>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [August 27, 2015, 5:18pm UTC](https://forum.kx.com/t/how-to-convert-char-to-date-or-time-type/10319 "2015-08-27T17:18:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![James11](https://avatars.discourse-cdn.com/v4/letter/j/e5b9ba/32.png) [@James11](https://forum.kx.com/u/James11)\
**Post date:** [August 27, 2015, 5:18pm UTC](https://forum.kx.com/t/how-to-convert-char-to-date-or-time-type/10319/1 "2015-08-27T17:18:00Z")

</div>

Hi,

How to convert char to date or time type?

e.g.

**char:“20150828”** is converted to **date:2015.08.28**

**char:“23:47:24”** is converted to **time:23:47:24.000**

Is there any function to make this?

---

<div class="post-metadata">

**Author:** ![charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@charlie1](https://forum.kx.com/u/charlie1)\
**Post date:** [August 27, 2015, 5:19pm UTC](https://forum.kx.com/t/how-to-convert-char-to-date-or-time-type/10319/2 "2015-08-27T17:19:00Z")

</div>

q)“D”$“20150828”  
2015.08.28  
q)“T”$“23:47:24”  
23:47:24.000

---

<div class="post-metadata">

**Author:** ![James11](https://avatars.discourse-cdn.com/v4/letter/j/e5b9ba/32.png) [@James11](https://forum.kx.com/u/James11)\
**Post date:** [August 27, 2015, 5:31pm UTC](https://forum.kx.com/t/how-to-convert-char-to-date-or-time-type/10319/3 "2015-08-27T17:31:00Z")

</div>

it works, thanks!

? 2015?8?28??? UTC+8??12:19:30?Charles Skelton???

> q)“D”$“20150828”  
> 2015.08.28  
> q)“T”$“23:47:24”  
> 23:47:24.000