On 06/07/11 21:47, Gavin Flower wrote:<br /><br /> I forgot the format required of the order number, so to get the
fullyesr, I should have used:<br /><font face="Courier New, Courier, monospace">to_char(day, 'YYYYMMDD')</font><br
/><br/> [...] <blockquote cite="mid:4E142F1A.8060900@archidevsys.co.nz" type="cite"><font face="Courier New, Courier,
monospace"> v_order_num := type::text ||<br /> '-' ||<br />
to_char(day,'YYMMDD') || <br /> '-' ||<br />
v_seq_new::text;</font></blockquote>[...]<br /><br /> Cheers,<br /> Gavin
