Loading

Filtering time from Date/Time in MS-Access

kannan

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...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gomathi Palaniswamy16y ago
Accepted answer
Hi friend,

Refer the below link
http://dotnetperls.com/datetime-1

With Regards,
Gomathi.P
kannan16y ago
Thank you for your kind reply.

I need the formatting in query itself.. So its easy to bind in datagrid. Any how i got the solution. There is one function "Format" is available to format Date/Time in access.

Select Format(Time_in,"hh:nn AM/PM") AS TIMEIN from demo

will return only time... refer the link below for more details
http://www.techonthenet.com/access/tables/format_date.php

Thanks again...