Obsidian/Recognition/Programing/Tibero/timestamp to char.md

7 lines
111 B
Markdown
Raw Permalink Normal View History

2024-07-14 03:37:03 +00:00
#tibero #SQL
```sql
to_char(to_timestamp(login_dt, 'yyyy-mm-dd hh24:mi:ss.ff3'), 'yyyyMMddhh24miss.ff3')
```