| Subject | time from timestamp |
|---|---|
| Author | Lauri Zoova |
| Post date | 2003-01-07T12:35:37Z |
Hi!
How can i get time portion of timestamp excluding seconds? (Besides
writing an udf that is..)
using select cast(ts_field as time) from table, i get seconds also.
using select cast(cast(ts_field as time) as char(5) from table, i get
'string truncation error or aritm...'.
BR,
Lauri
How can i get time portion of timestamp excluding seconds? (Besides
writing an udf that is..)
using select cast(ts_field as time) from table, i get seconds also.
using select cast(cast(ts_field as time) as char(5) from table, i get
'string truncation error or aritm...'.
BR,
Lauri