web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Database Date Format
Microsoft Dynamics AX (Archived)

Database Date Format

(0) ShareShare
ReportReport
Posted on by LeeRoberts 695

Hi

Is the date in the database always in the format "yyyy-mm-dd hh:mm:ss" and when it is displayed in Dax - inthe users preferred date format?

Because when I capture a logUpdate - the dates are always "yyyy-mm-dd"?

*This post is locked for comments

I have the same question (0)
  • Pooja Karki Profile Picture
    Pooja Karki 3,045 on at
    RE: Database Date Format

    Hi,

     Date format of database is based on system date format, when you change your system date format AX will use the same format of your machine.

  • LeeRoberts Profile Picture
    LeeRoberts 695 on at
    RE: Database Date Format

    Thanks for the reply

    When you say machine - do you mean OS Server regional settings

    I seen that if I change OS regional settings they are reflected in Dax UI - but the database format stays the same - it;'s the database format that I want to know about - why does it use the same setting how does it get it's setting?

  • Pooja Karki Profile Picture
    Pooja Karki 3,045 on at
    RE: Database Date Format

    HI,

     In which table you want to specify date format.

  • LeeRoberts Profile Picture
    LeeRoberts 695 on at
    RE: Database Date Format

    Hi

    It's not to do with any table in particular - I am looking to find out why Sql server is using the date format "yyyy-mm-dd hhh:mm:ss" - is this set at install time for Dax (do you have an option to change) - or is it s Dax Sql DB standard?

  • Martin Dráb Profile Picture
    Martin Dráb 236,320 Most Valuable Professional on at
    RE: Database Date Format

    DateTime in database is stored as two integer values, it doesn't know anything about string formats.

    What you consider as "database format" is just a format in which some tool displays the binary data to you. Where do you see the "database format"?

  • LeeRoberts Profile Picture
    LeeRoberts 695 on at
    RE: Database Date Format

    In SalesTable there is the field called [DELIVERYDATE] which has a datatype DateTime - I was wondering what determines the format in the database (as when i catch an event LogUpdate for example) - this database format is pass to my external WCF service

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 236,320 Most Valuable Professional on at
    RE: Database Date Format

    Again, there is no "format in the database", datetime is simply not a string at all!

    If "LogUpdate event" means Application.logUpdate(), then it runs on AOS server, not database server, and AX takes default date format from the operation system running the AOS.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans