getdate() implementation

[TimWynne]

Is is possible to change the getdate() implementation in 12.5?

we have many existing stored procs which call the function, and it would be good to make the returned value independent of the system time - i.e. use the current system time, but use a static date or year.

current solution is using a view, but this uses several string converstions and concats which are not sufficiently performant.

Any ideas for lower level access to the API?

Tim

 

[JMCraig]

One option would be to add the JSQL add-on and create your own function using a Java class. You might also get better performance from a stored procedure (which can be set up to return a value, but only into a declared variable).

If, in the months since you posted this, you came up with another solution, I'd be interested to hear it.

John
nsjmcraig@netscape.net