I have a PHP DateTime Object where the timezone has already been set to America/New_York. I’d like to clone this object and and change the timezone of the clone to be UTC. The resulting time should be the same moment, but the time of day should be adjusted for the new timezone. Most examples I… Read More Converting PHP DateTime Object from One Timezone to Another
The dataframe contains an index whose dytpe is datetime64[s]. df ticker close 2008-01-28 aacg 0.7380 2008-01-29 aacg 0.6797 2008-01-30 aacg 0.6603 2008-01-31 aacg 0.7418 2008-02-01 aacg 0.7387 Write the df into table quote: df.to_sql(‘quote’,con=engine,index=True) Show records in postgresql: select * from quote; index | ticker | close ———————+——–+——– 2008-01-28 00:00:00 | aacg | 0.738 2008-01-29… Read More How can write the datetime index into table with date type?
How can I subtract the system date from the created task date in SQL ORACLE to get the difference in days, hours, minutes? I tried this code but i get wrong values: TO_CHAR(TO_DATE(‘1970-01-01 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) + (sysdate – a.CREATE_DATE_PL ), ‘dd:hh24:mi:ss’) AS TT_LIFETIME My results is below (the report has been generated 02.06 14:05 enter… Read More SQL ORACLE, How to subtract sysdate?
I am working with a date format that looks like this: 2023-04-25T16:00:00+00:00 I want to add 5 days to the current_date and return the same format as above I tried this: from datetime import datetime, timedelta today = datetime.now() iso_date = today.isoformat() iso_date += timedelta(days=5) which throws: TypeError: can only concatenate str(not "datetime.timedelta") to str… Read More Incrementing ISO date by 5 days
I have a pandas DataFrame with a datetime column (‘time’) in m/d/yyyy h:mm:ss format. I need to calculate the difference between each row and the previous row and display the result in a new column (‘SEC’) in seconds. For example: time SEC 4/18/2023 2:43:00 4/18/2023 3:13:00 1800 4/18/2023 3:35:53 1373 4/18/2023 3:36:03 10 >Solution :… Read More Calculate time difference in seconds in pandas
I want to subtract dt2 (2023-12-31) from dt1 (2023-01-01) in c#, but when i try to debug the codes it says " System.FormatException: ‘String ‘2023-12-31 08:00:00′ was not recognized as a valid DateTime.’ " my codes: DateTime dt1 = DateTime.Parse("2023-01-01 08:00:00"); DateTime dt2 = DateTime.Parse("2023-12-31 08:00:00"); TimeSpan diff = dt2.Subtract(dt1); Console.WriteLine(diff.ToString()); How i can fix… Read More how to parse a string to DateTime in c#?
I am trying to convert a date stored as string to DateTime using DateTime.ParseExact like below var myDate = DateTime.ParseExact("3/14/2023 4:08:30 PM", "M/dd/yyyy h:mm:ss tt", null); but I keep getting a FormatExceptionerror on that line. I have tried tweaking the format, but nothing works. What am I missing here? >Solution : Your existing code uses… Read More Keep getting FormatException on DateTime.ParseExact
It has one data frame with a column of model and date like below df = pd.DataFrame({‘model’:[‘A’,’B’,’C’,’D’, ‘E’,’F’,’G’,’I’,’J’,’K’], ‘date’:[‘2022-10-28 12:10:28 AM’,’2022-12-07 12:12:07 AM’,’2022-12-07 12:12:07 AM’,’2022-12-07 12:12:07 AM’, ‘2022-12-08 12:12:08 AM’,’2022-12-10 12:12:10 AM’,’2023-02-22 12:02:22 AM’,’2023-02-22 12:02:22 AM’, ‘2023-02-24 12:02:24 AM’,’2023-03-04 12:03:04 AM’]}) I want to distinguish between the 1st and 15th of each month and the… Read More To put numbers in a class column, separating data frames by date
Using the following code i am reading a csv file into a dataframe and convert the time column ‘object’ into a ‘datetime’ format. # Use the read_csv function to create a DataFrame from the CSV file shackles = pd.read_csv(path_data_shackles, delimiter=’;’) print(shackles.dtypes) # Convert time column to datetime column shackles[‘time’] = pd.to_datetime(pd.Series(shackles[‘time’]), format="%H:%M:%S:%f") print(”) print(shackles[‘time’].iloc[3688]) print(”)… Read More Handling different length digits in datetime
I want to get yesterday’s record in exact now hour and minute time Forexample this is today’s date and time 2023-04-22 14:32:15 I want the records in 2023-04-21 14:32:15 I tried some queries like bottom but non of them works: SELECT CONCAT( TIMESTAMPDIFF(DAY,’2023-04-21 13:45:00′, ‘2023-04-22 13:45:00’)); SELECT * FROM message WHERE datetime BETWEEN CURDATE() -… Read More get exact now time of yesterday day data mysql