Sql format string to Date : Date Time Format « Date Time « C# / C Sharp

1. C# / C Sharp
2. Date Time
3. Date Time Format

Sql format string to Date

    

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;

static class Util
{
    public static string sql2date(DateTime date)
    {
        DateTime UTCDate = date.ToUniversalTime();
        string frmDate = date.ToString("ddd, dd MMM yyyy HH:mm:ss +0000");
        return frmDate;
    }

    public static string sql2date2(DateTime date)
    {
        DateTime UTCDate = date.ToUniversalTime();
        string frmDate = date.ToString("yyyy-MM-dd HH:mm:ss");
        return frmDate;
    }
}

   
    
    
    
  

Related examples in the same category

1.	use the ToString() method to convert a DateTime to a string
2.	use the ToLongTimeString() and ToShortTimeString() methods to convert the time parts of a DateTime to long and short time strings
3.	use the FromFileTime() method to convert an operating system file timestamp to a DateTime
4.	use the ToFileTime() method to convert a DateTime to an operating system file timestamp
5.	Format time and date information 1
6.	Format time and date information 2
7.	demonstrates culture formatting
8.	DateTime ToString with CultureInfo
9.	The next example formats a DateTime with invariant culture. Invariant culture is always the same, regardless of the computer's settings:
10.	Request a specific culture (english language in Great Britain):
11.	Compare the results of choosing InvariantInfo with those of choosing CurrentInfo:
12.	Format date value as short date format
13.	Long date format
14.	Sortable date format
15.	Universal sortable date format
16.	Universal full date/time
17.	RFC1123 date format
18.	Month date format
19.	Year date format
20.	General date long time format
21.	General date/short time format
22.	Full date long time format
23.	Full date short time format
24.	Long time date format
25.	Short time date format
26.	Contains helper for converting to and from the date formats
27.	DateTime Format: %M
28.	DateTime format: MMMM dd, yyyy (dddd)
29.	DateTime Format: MM-dd-yy
30.	DateTime Format: d, M
31.	DateTime Format: d MMMM
32.	DateTime Format: dd,MM
33.	DateTime Format: ddd d MMM
34.	DateTime Format: ddd d MMM (fr-FR)
35.	DateTime Format: dddd dd MMMM
36.	DateTime Format: dddd dd MMMM (it-IT)
37.	DateTime Format: : hh:mm:ss.f
38.	DateTime Format: hh:mm:ss.F
39.	DateTime Format: hh:mm:ss.ff
40.	DateTime Format: hh:mm:ss.FF (2)
41.	DateTime Format: "hh:mm:ss.fff
42.	DateTime Format: hh:mm:ss.FFF
43.	DateTime Format: MM/dd/yyyy g
44.	DateTime Format: h:m:s.F t
45.	DateTime Format: hh:mm:ss.ff tt
46.	DateTime Format: H:mm:ss
47.	DateTime Format: HH:mm:ss
48.	DateTime Format: %K
49.	DateTime Format: hh:mm:ss tt
50.	DateTime Format: (M) MMM, MMMM
51.	DateTime Format: dd, MM
52.	DateTime Format: dddd dd MMMM (2)
53.	DateTime Format: yyyyy
54.	DateTime Format: %z
55.	DateTime Format: zzz, zz
56.	DateTime Format: %h
57.	DateTime Format: h \\h m \\m
58.	Format decimal with different cultures
59.	dateTime.ToString("dd/MM/yyyy ")
60.	dateTime.ToString("dd/MM/yyyy hh:mm")
61.	DateTime to short and long String
62.	Gets the pretty date.
63.	Converts a DateTime object into a unix timestamp number.
64.	To Unix time
65.	Format Time as ##:##:##
66.	Format Time as ##/##/## (2)