dradovic / MigSharp

Mig# (MigSharp) is a .NET framework for database migrations and versioning
Other
106 stars 34 forks source link

Add support for defaulting datetime fields to UTC #37

Closed mikeycooper closed 8 years ago

mikeycooper commented 12 years ago

We often default our datetime fields to the current date in UTC format (GETUTCDATE()) rather than the server's timezone. This is especially useful for apps used by users in multiple timezones. We'd love to see support in the official MigSharp for this. I know it's possible in Oracle using SYS_EXTRACT_UTC(SYSTIMESTAMP), but I don't know enough about Oracle to test it myself.

dradovic commented 12 years ago

Yes, that's a good one. It should be added to Mig#. However, I'm still traveling around the globe with only a backpack with no VS in it. Do you have any capacity to implement it and set up a pull-request? If you add an integration test, I can try to persuade my former team to update and check it if it runs on all platforms...

mikeycooper commented 12 years ago

If I can figure out the pull request, I'll do so.

Sent from my Windows Phone From: dradovic Sent: 3/18/2012 9:12 AM To: mikeycooper Subject: Re: [MigSharp] Add support for defaulting datetime fields to UTC (#37) Yes, that's a good one. It should be added to Mig#. However, I'm still traveling around the globe with only a backpack with no VS in it. Do you have any capacity to implement it and set up a pull-request? If you add an integration test, I can try to persuade my former team to update and check it if it runs on all platforms...


Reply to this email directly or view it on GitHub: https://github.com/dradovic/MigSharp/issues/37#issuecomment-4561106

dradovic commented 11 years ago

Hello Mikey Are you still interested in this feature? I'm back in front of a Visual Studio and I have a build environment at disposal including Oracle. So we could work on this.

anishpateluk commented 10 years ago

+1

dradovic commented 10 years ago

Please read the first section of https://github.com/dradovic/MigSharp/wiki.

dradovic commented 8 years ago

Available in 3.1.0.