On 06/07/11 21:47, Gavin Flower wrote:I forgot the format required of the order number, so to get the full yesr, I should have used:
to_char(day, 'YYYYMMDD')
[...]
v_order_num := type::text ||
'-' ||
to_char(day, 'YYMMDD') ||
'-' ||
v_seq_new::text;
[...] Cheers, Gavin
