PYTHON

parse string to datetime

dependencies:
  intl: ^0.17.0
  
import 'package:intl/intl.dart';

DateFormat dateFormat = DateFormat("yyyy-MM-dd HH:mm:ss");

String string = dateFormat.format(DateTime.now()); //Converting DateTime object to String

DateTime dateTime = dateFormat.parse("2019-07-19 8:40:23"); //Converting String to DateTime object

string to datetime

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))

Convert String to DateTime

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)

convert str to datetime

import datetime

# str value "Apr 2, 2019" convert into any format. 
datetime.datetime.strptime('Apr 2, 2019', '%b %d, %Y').strftime('%a, %d %b %Y')

datetime string to datetime object

// To convert json datetime string to datetime object in c#
// Try this

// For instance if the json string is in this format: "/Date(1409202000000-0500 )/"
// Then wrap it like below

string sa = @"""/Date(1409202000000-0500)/""";

// Create a new instance of datetime object
DateTime dt = new DateTime();

// Deserialize the json string to datetime object
dt = JsonConvert.DeserializeObject<DateTime>(sa);


// Output
// dt = "2014-08-28 3.00.00 PM"

Convert string to datetime python

 Load libraries
import pandas as pd
from datetime import timedelta

# Loading dataset and creating duration column
url = 'https://drive.google.com/uc?id=1YV5bKobzYxVAWyB7VlxNH6dmfP4tHBui'
df = pd.read_csv(url, parse_dates = ['pickup_datetime', 'dropoff_datetime', 'dropoff_calculated'])
df["duration"] = pd.to_timedelta(df["duration"])

# Task 1 - filter to only rides with negative durations
df_neg = df[___["___"] < ___(___)]

# Task 2 - iterate over df_neg rows to find inconsistencies
count = 0
for i, row in df_neg.___():
  # Compare minutes of dropoff_datetime and dropoff_calculated
  if row["___"].___ != row["___"].minute:
    # Print these two columns
    print(___[["dropoff_datetime", "dropoff_calculated"]])
    # Task 3 - count number of rows having hour greater-equal than 12
  if row["___"].___ >= ___:
    count ___

print(f"There are {count} rows in df_neg having hour greater-equal than 12.")

convert string to datetime

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);