Open Closed

UTC Time format Issue - PostgreSQL #4274


User avatar
0
Repunjay created

Application Upgraded to 6.0. got the UTC Time format issue while seeding the data, as per below link we can revert back that UTC thing. https://docs.abp.io/en/abp/latest/Migration-Guides/Abp-5_0

How to do the same thing for Postgre SQL?

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

If you're creating a bug/problem report, please include followings:

  • ABP Framework version: vX.X.X
  • UI type: Angular / MVC / Blazor
  • DB provider: EF Core / MongoDB
  • Tiered (MVC) or Identity Server Separated (Angular): yes / no
  • Exception message and stack trace:
  • Steps to reproduce the issue:"

5 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    // https://www.npgsql.org/efcore/release-notes/6.0.html#opting-out-of-the-new-timestamp-mapping-logic
    AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);
    
  • User Avatar
    0
    Repunjay created

    hi

    // https://www.npgsql.org/efcore/release-notes/6.0.html#opting-out-of-the-new-timestamp-mapping-logic 
    AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true); 
    

    do I need to add this line in all dbcontext files or how?

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    MyProjectNameEntityFrameworkCoreModule and MyProjectNameDbContextFactory

  • User Avatar
    0
    Repunjay created

    hi

    MyProjectNameEntityFrameworkCoreModule and MyProjectNameDbContextFactory

    is this change only related to Identity or other dbcontexts also need change? Please confirm on this.

  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    Yes, You can create the latest template project with the PostgreSQL database, we have built this code.

Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
Do you need assistance from an ABP expert?
Schedule a Meeting
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v9.2.0-preview. Updated on March 25, 2025, 11:10