• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 49 views
  • Users 0 members are here
Related

trying to change date time to non-military datetime

Mary Opdahl
$organization

trying to change date time to non-military datetime

Parents
  • $organization

    Mary -

    I'm assuming you want the a date field in a query from the standard format mm-dd-yyyy hh:mm:ss.xxx? If you are asking how to change it in SQL, you can use both the CONVERT or CAST function in your SQL query. There are many resources on the internet to explain how to use the function in your query. 

    You would not want to change the field type of a table, however. 

    Hope this helps.

Reply
  • $organization

    Mary -

    I'm assuming you want the a date field in a query from the standard format mm-dd-yyyy hh:mm:ss.xxx? If you are asking how to change it in SQL, you can use both the CONVERT or CAST function in your SQL query. There are many resources on the internet to explain how to use the function in your query. 

    You would not want to change the field type of a table, however. 

    Hope this helps.

Children
No Data