2
Reply

Filtering time from Date/Time in MS-Access

kannan

kannan

Sep 21 2010 8:47 AM
8.5k
Hi friends,

         I have a table in MS-Access "demo", in that i have column "Time_in" as DATE/TIME, and inserting the value by "Time()" function.
         While browsing in access it is showing only time. But while displaying the same in Datagrid (WPF) it is showing time with date like this "30-Dec-1899 2:02:18 PM"

                 here date is wrong but time is right.
From that data i want to extract only time and display in datagrid....

Please guide me...

Thanks in advance...


Answers (2)
Next Recommended Forum