# How to write timetamp with microsecond precision?

**URL:** <https://forum.yugabyte.com/t/how-to-write-timetamp-with-microsecond-precision/552>\
**Category:** General\
**Created:** [October 29, 2019, 9:51am UTC](https://forum.yugabyte.com/t/how-to-write-timetamp-with-microsecond-precision/552 "2019-10-29T09:51:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fulton\_Fu](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/fulton_fu/32/169_2.png) [@Fulton\_Fu](https://forum.yugabyte.com/u/Fulton_Fu)\
**Post date:** [October 29, 2019, 9:51am UTC](https://forum.yugabyte.com/t/how-to-write-timetamp-with-microsecond-precision/552/1 "2019-10-29T09:51:47Z")

</div>

Hello,

It throw exception when I try insert a value ‘2018-05-04 22:46:33.436000’ for timestamp column,  
and it succeed if replace with ‘2018-05-04 22:46:33.436’.  
So how to write timestamp with microsecond precision?

Thank you.

---

<div class="post-metadata">

**Author:** ![neha](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/neha/32/231_2.png) [@neha](https://forum.yugabyte.com/u/neha)\
**Post date:** [October 30, 2019, 12:27am UTC](https://forum.yugabyte.com/t/how-to-write-timetamp-with-microsecond-precision/552/2 "2019-10-30T00:27:57Z")

</div>

> [@Fulton\_Fu](#):
>
> 2018-05-04 22:46:33.436000

Hi @Fulton_Fu,  
We don’t support microsecond date time in YCQL. Can you please open a github issue if you need this?

Note that YSQL does support it:  
For example,

```auto
./bin/ysqlsh
CREATE TABLE ts(a timestamp primary key);
INSERT INTO ts values(‘2018-05-04 22:46:33.4360105’);

```