Getting Only the Date Part of a Date/Time Stamp in ACCESS
"select datefield from tablename"
06/15/2007 12:00:00 PM
"Select FORMAT(datefield, 'd /MM/ yyyy') as datefield from tablename"
15/06/2007
"Select FORMAT(datefield, 'MM /d / yyyy') as datefield from tablename"
06/15/2007
No comments:
Post a Comment