Re: [SQL] Invalid Input syntax for type bigint

2005-01-23 Thread Michael Fuhr
On Sun, Jan 23, 2005 at 02:59:36PM -0800, Ryan Miranda wrote: > I am trying to run the proc below but get an error : invalid input > syntax for type bigint: "2004-10-26" Can anyone suggest what I am > doing wrong here? Apparently you're trying to use a date where a bigint is expected. One possibi

[SQL] Invalid Input syntax for type bigint

2005-01-23 Thread Ryan Miranda
hello everyone, I am trying to run the proc below but get an error : invalid input syntax for type bigint: "2004-10-26" Can anyone suggest what I am doing wrong here? Rx -- Function: public.getdateallocated(date, date) DROP FUNCTION public.getdateallocated(date, date); CREATE OR REPLACE FUNCTI