Hi
           When I insert a record into a table DateTime Field with GETDATE() .It will display both Date and Time data.How can I insert only the Date or Time Portion ? If I want to insert the current time into the time field what function in MSDE can I use?
                                                                            Thank
                                                                                   doctorsom

There is no time data type in MSDE or SQL Server.

Try this to get only the time:

select convert(varchar(8),getdate(), 108)

look up convert in books on line.



Sal