🚀 go-pugleaf

Sorry, a small mistake (char should be 4 characters):

Update table set somefield =
   case
     when extract(day from current_date) < 10 then
       '0' || extract(day from current_date)
     else extract(day from current_date)
   end ||'/'
   case
     when extract(month from current_date) < 10 then
       '0' || extract(month from current_date)
     else extract(month from current_date)
   end ||'/'
   substring(cast(extract(year from current_date) as char(4))
             from 3 for 2)
where
<condition>

Svein Erling Tysv�r wrote:
> Try something like
> 
> Update table set somefield =
>   case
>     when extract(day from current_date) < 10 then
>       '0' || extract(day from current_date)
>     else extract(day from current_date)
>   end ||'/'
>   case
>     when extract(month from current_date) < 10 then
>       '0' || extract(month from current_date)
>     else extract(month from current_date)
>   end ||'/'
>   substring(cast(extract(year from current_date) as char(2)) from 3 for 2)
> where
> <condition>
> 
> The syntax may or may not be different in InterBase.
> 
> HTH,
> Set
> 
> 
> Craig Cookesley wrote:
>> Hi
>>
>> I need to update a field defined as varchar(8) with a datetime field 
>> in a trigger
>>
>> The field is used extensive in code so to change the field type would 
>> be a big job
>>
>> i was hoping to cast or convert the datatime field to string before 
>> update
>>
>> Any ideas would be appreciated
>>
>> Thanks in advance
>>
>> Craig