Hi,
I previosuly used SQLT on computed fields. This now longer appears to work. I believe the new syntax is PosdtgreSQL. Can you tell me how I can extract the week from a date in a computed field? Also how can I display today's date. I can displat the timestanp using 'now()' but I can't figure out how to extract just the date portion.
Thanks for you help,
David.
Solved! Go to Solution.
Solved by Andrew.Shaw. Go to Solution.
Hello David,
You can extract the day as a string by using the following formula: to_char(FIELD_NAME,'dd').
However, if the target data type is numerical, use the following formula: to_number(to_char(FIELD_NAME,'dd'),'99').
Best regards,