Skip to main content

DateTime.ToString() formats

Zilele astea m-am trezit cu niste probleme la o aplicatie la care am lucrat impreuna cu niste colegi. Formatul la ora nu era consistent in toata aplicatia. In unele locatii aparea sub forma 04:50, iar in alte locatii aparea sub forma 16:50.
Problema principala a fost ca s-a folosit formatarea fara a se cunoaste exact ce se afiseaza cand se foloseste HH sau hh.
Mai jos as vrea sa ne uitam la metoda ToString a unui DateTime. Aceasta primeste ca si parametru un string prin intermediul caruia se poate specifica modul de formatare a datei.
  • yyyy - o sa afiseze anul in formatul 2012
  • MMMM - luna in litere( iulie, august, ...)
  • MM - luna in cifre( 07, 08)
  • dddd - ziua din saptamana in litere( luni, marti)
  • ddd - ziua in litere dar prescurta
  • dd - ziua curenta din luna( 20, 31, ...)
  • H - ora in format 24, iar daca ora e mai mica ca 10 se va afisa o singura cifra, fara 0( 1, 2, 14)
  • HH - ora in format 24, iar daca ora e mai mica ca 10 se va afisa un 0 la inceput( 01, 02, 14)
  • h - ora in format AM/PM, iar daca ora e mai mica ca 10 se va afisa o singura cifra, fara 0( 1, 2, 2)
  • hh- ora in format AM/PM, iar daca ora e mai mica ca 10 se va afisa un 0 la inceput( 01, 02, 02)
  • tt - daca este AM sau PM( AM, PM)
  • mm - minute
  • ss - secunde


  1. No hai... asta e si in MSDN.

  2. Multumesc Andrei ca ai dat aceste linkuri. Mai mult ca sigur pentru cine vroia sa afle aceste lucruri putea sa foloseasca Bing :)


Post a Comment

Popular posts from this blog

How to check in AngularJS if a service was register or not

There are cases when you need to check in a service or a controller was register in AngularJS.
For example a valid use case is when you have the same implementation running on multiple application. In this case, you may want to intercept the HTTP provider and add a custom step there. This step don’t needs to run on all the application, only in the one where the service exist and register.
A solution for this case would be to have a flag in the configuration that specify this. In the core you would have an IF that would check the value of this flag.
Another solution is to check if a specific service was register in AngularJS or not. If the service was register that you would execute your own logic.
To check if a service was register or not in AngularJS container you need to call the ‘has’ method of ‘inhector’. It will return TRUE if the service was register.
if ($injector.has('httpInterceptorService')) { $httpProvider.interceptors.push('httpInterceptorService&#…

ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded

Today blog post will be started with the following error when running DB tests on the CI machine:
threw exception: System.InvalidOperationException: The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer' registered in the application config file for the ADO.NET provider with invariant name 'System.Data.SqlClient' could not be loaded. Make sure that the assembly-qualified name is used and that the assembly is available to the running application. See for more information. at System.Data.Entity.Infrastructure.DependencyResolution.ProviderServicesFactory.GetInstance(String providerTypeName, String providerInvariantName) This error happened only on the Continuous Integration machine. On the devs machines, everything has fine. The classic problem – on my machine it’s working. The CI has the following configuration:

TeamCity.NET 4.51EF 6.0.2VS2013
It seems that there …

Entity Framework (EF) TransactionScope vs Database.BeginTransaction

In today blog post we will talk a little about a new feature that is available on EF6+ related to Transactions.
Until now, when we had to use transaction we used ‘TransactionScope’. It works great and I would say that is something that is now in our blood.
using (var scope = new TransactionScope(TransactionScopeOption.Required)) { using (SqlConnection conn = new SqlConnection("...")) { conn.Open(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = conn; sqlCommand.CommandText = ... sqlCommand.ExecuteNonQuery(); ... } scope.Complete(); } Starting with EF6.0 we have a new way to work with transactions. The new approach is based on Database.BeginTransaction(), Database.Rollback(), Database.Commit(). Yes, no more TransactionScope.
In the followi…