Re: [SQL] how to get decimal to date form

Okay thanks, this is how I ended up doing it: TO_DATE(SUBSTR(TO_CHAR(rec_num,999),1,6),'0YMMDD') AS Date Another question though... I have a field that is of type numeric so when I want to divide it like this: SUM(vc_elapsed_time)/60.0 postgre complains "Unable to identify an operator '/'

[SQL] listing foreign keys

is there any way to view the existing foreign keys in a database schema? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]