C-Sharp ConvertToDateTime Example – Code Sample Syntax

C-Sharp ConvertToDateTime Example – Code Sample Syntax

Purpose: – Illustrates using .

Purpose:
Converts any valid date and time into date data type

Syntax:
Convert.ToDateTime(expression)

Parameters Description
expression any valid representation of date and time

Result Data Type Description
date returns date

Quick Example
Convert.ToDateTime(“September 12, 2011”) // Returns 9/12/2011 12:00:00 AM

Step 1: Click cs to Cut-n-paste code into clsConvertToDateTime.cs

using System;
 
public class clsConvertToDateTime
{
 
    public void Main()
    {
 
 
        //****************************************************************************************
        // Purpose: Converts any valid date and time into date data type
        //
        // Syntax: 	Convert.ToDateTime(expression)
        //
        // Parameter1: expression - any valid representation of date and time
        //
        // Result: date - returns date
        //
        // Quick Example: Convert.ToDateTime("September 12, 2011") // Returns 9/12/2011 12:00:00 AM
        //
        //****************************************************************************************
        // This example is from http://idealprogrammer.com
 
        Console.WriteLine("Example #1: 	Convert.ToDateTime(expression)");
 
        DateTime date1 = Convert.ToDateTime("September 12, 2011");
 
        Console.WriteLine(date1); // Returns 9/12/2011 12:00:00 AM
 
 
        //write blank line to make output easier to read
        Console.WriteLine();
 
        Console.WriteLine("Example #2: 	Convert.ToDateTime(expression)");
 
        DateTime date2 = Convert.ToDateTime("3:08:40 PM");
 
        Console.WriteLine(date2); // Returns 1/1/0001 3:08:40 PM
 
        //write blank line to make output easier to read
        Console.WriteLine();
 
        Console.WriteLine("Example #3: 	Convert.ToDateTime(expression)");
 
        DateTime date3 = Convert.ToDateTime("September 12, 2011 3:08:40 PM");
 
        Console.WriteLine(Convert.ToDateTime(date3)); // Returns September 12, 2011 3:08:40 PM
 
        //Prevent console from closing before you press enter
        Console.ReadLine();
 
    }
 
}

Step 2: Click cs to Cut-n-paste code into Module1.cs

Module Module1
 
    Sub Main()
 
 
        Dim myclsConvertToDateTime As New clsConvertToDateTime
        myclsConvertToDateTime.Main()
 
 
 
    End Sub
 
End Module

Prerequistes:

  1. Install C-Sharp (Express or Standard Edition)
  2. Install SQL Server Express
  3. Download Northwind and pubs Database
  4. Attach Northwind Database to Databases in Sql Express
  5. Attach pubs Database to Databases in Sql Express

Notes:

  • Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
  • You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Module1.cs

Instructions:
C-Sharp Syntax Functions ConversionFunctions ConvertToDateTime

  1. Use C-Sharp 2010 Express or Standard Edition
  2. Create new project;
    • Click File/New Project
    • Select Console Application Template
    • Select C-Sharp for Language
    • name of project could be C-Sharp_Syntax.
  3. Add New folder named “Functions”
    • Right-click project name in solution explorer;
    • add new folder;
    • name of folder could be: Functions
  4. Add New subfolder named “ConversionFunctions”
    • Right-click Functions folder in solution explorer;
    • add new folder;
    • name of folder could be: ConversionFunctions
  5. Add New subfolder named “TypeConversionFunctions”
    • Right-click ConversionFunctions folder in solution explorer;
    • add new folder;
    • name of folder could be: TypeConversionFunctions
  6. Add Class Named clsConvertToDateTime to TypeConversionFunctions folder
    • Right-click TypeConversionFunctions folder;
    • add new item;
    • Select class
    • Class name could be clsConvertToDateTime
  7. Click on cs in code in step 1 above to copy code into clsConvertToDateTime.cs
  8. Click on cs in code in step 2 above to copy code into Module1.cs
  9. Click green arrow or press F5 to run program