xxxxxxxxxx
from datetime import datetime
# EXEMPLE 1
dt_string = "12/11/2018 09:15:32"
# Considering date is in dd/mm/yyyy format
dt_object1 = datetime.strptime(dt_string, "%d/%m/%Y %H:%M:%S")
print("dt_object1 =", dt_object1)
# Considering date is in mm/dd/yyyy format
dt_object2 = datetime.strptime(dt_string, "%m/%d/%Y %H:%M:%S")
print("dt_object2 =", dt_object2)
#EXEMPLE 2
date_string = "21 June, 2018"
print("date_string =", date_string)
print("type of date_string =", type(date_string))
date_object = datetime.strptime(date_string, "%d %B, %Y")
print("date_object =", date_object)
print("type of date_object =", type(date_object))
xxxxxxxxxx
import pandas as pd
# Define string
date = '04/03/2021 11:23'
# Convert string to datetime format
date1 = pd.to_datetime(date)
# print to_datetime output
print(date1)
# print day, month and year separately from the to_datetime output
print("Day: ", date1.day)
print("Month", date1.month)
print("Year", date1.year)
xxxxxxxxxx
record_date = General['Start Date'].astype('string')
record_date = pd.to_datetime(record_date, format="%Y/%m/%d %H:%M")
xxxxxxxxxx
date = datetime.datetime.strptime('2019-3-16T5-49-52-595Z','%Y-%m-%dT%H-%M-%S-%f%z')
date_time = date.strftime('%Y-%m-%dT%H:%M:%S.%fZ')
xxxxxxxxxx
declare @fecha datetime
set @fecha = GETDATE()
select convert(date ,@fecha)
xxxxxxxxxx
string CurrentDate = "06/04/2020";
// Creating new CultureInfo Object
// You can use different cultures like French, Spanish etc.
CultureInfo Culture = new CultureInfo("en-US");
//Use of Convert.ToDateTime()
DateTime DateObject = Convert.ToDateTime(CurrentDate, Culture);
Console.WriteLine("The Date is: " + DateObject.Day + " " + DateObject.Month + " " + DateObject.Year);