# Crate Timestamp

**URL:** <https://community.cratedb.com/t/crate-timestamp/186>\
**Category:** Documentation\
**Created:** [April 4, 2019, 1:27pm UTC](https://community.cratedb.com/t/crate-timestamp/186 "2019-04-04T13:27:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![julianmar](https://avatars.discourse-cdn.com/v4/letter/j/ed655f/32.png) [@julianmar](https://community.cratedb.com/u/julianmar)\
**Post date:** [April 4, 2019, 1:27pm UTC](https://community.cratedb.com/t/crate-timestamp/186/1 "2019-04-04T13:27:53Z")

</div>

hi,

is there a way to force timestamps to be in seconds instead of milliseconds?  
Our Framework and PHP use seconds instead of milliseconds.  
This would make it way easier if I can force the timestamp to be in seconds.

Thanks in advance  
J

---

<div class="post-metadata">

**Author:** ![julianmar](https://avatars.discourse-cdn.com/v4/letter/j/ed655f/32.png) [@julianmar](https://community.cratedb.com/u/julianmar)\
**Post date:** [April 4, 2019, 2:38pm UTC](https://community.cratedb.com/t/crate-timestamp/186/2 "2019-04-04T14:38:22Z")

</div>

I worked around this by sending a Iso 8601 String

---

<div class="post-metadata">

**Author:** ![roman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/roman/32/36_2.png) [@roman](https://community.cratedb.com/u/roman)\
**Post date:** [April 26, 2019, 1:39pm UTC](https://community.cratedb.com/t/crate-timestamp/186/3 "2019-04-26T13:39:17Z")

</div>

Hi @julianmar,

Maybe using a generated column would also be a solution: [https://crate.io/docs/crate/reference/en/latest/general/ddl/generated-columns.html](https://crate.io/docs/crate/reference/en/latest/general/ddl/generated-columns.html)

Best  
Roman

---

<div class="post-metadata">

**Author:** ![roman](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/roman/32/36_2.png) [@roman](https://community.cratedb.com/u/roman)\
**Post date:** [April 26, 2019, 1:45pm UTC](https://community.cratedb.com/t/crate-timestamp/186/4 "2019-04-26T13:45:04Z")

</div>

Other option might be `SELECT date_trunc('second', ts) FROM ...`