Hi,
At 09:43 AM 7/5/2002, you wrote:
>but i use the same table in other appication and the can`t handle text
>field so i need a datetime field whit only the tine in it
It can't be done, not in SQL Server.
Use the datetime field, but then use either Tango's FORMAT attribute (e.g.
<@COLUMN "myTable.myDatetimeColumn" FORMAT="datetime:%H:%M">) or use SQL's
date/time functions in your SELECT (e.g. SELECT DATEPART(hh,
myTable.myDatetimeColumn), DATEPART(mi, myTable.myDatetimeColumn)).
Eric
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
