Are you using the <@datetosecs> on an insert or update to the database?
Transact-sql has DATEDIFF that allows results in seconds.
If you want to use the ms sql statement only, in a direct-dbms:
select DATEDIFF(s,Begin_date,End_date)
Ted
-----Original Message-----
From: Tom Ferguson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2008 1:18 PM
To: [email protected]
Subject: Witango-Talk: User defined SQL function
Does anyone have/use a UDF for MS SQL that works similarly to the
<@datetosecs> Witango metatag?
I'm not smart enough to write one. LOL!
TIA
Tom Ferguson
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
