[Solved] Timestampdate to string or number

[gkick]

Hi All,

How can I convert the year contained in a timestamp to a string in order to update another field? Have experimented with the convert and substring function but to no avail

Thks

[Sliderule]

Use the built-in function TO_CHAR or YEAR.

For Example Run the following Query:

Code: Select all

Select DISTINCT 
   CURRENT_TIMESTAMP as "CUR_TS",
   YEAR(CURRENT_TIMESTAMP) as "INT_YEAR ",  -- Returns an integer range 1-9999
   TO_CHAR(CURRENT_TIMESTAMP,'YYYY') as "TO_CHAR",  -- Returns text string
   TO_CHAR( {TS '2027-12-28 15:30:27'},'YYYY') as "TO_CHAR_2027" -- Returns text string
From INFORMATION_SCHEMA.SYSTEM_TABLES

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

[gkick]

Beautiful, thank you Sliderule

GK