Python Forum
Convert from datetime to time.struct_time object
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Convert from datetime to time.struct_time object
#1
Hi all,

I need your help with my curent code. I have stored the datetime object into the list after I have pulled the string from the database. Now I would like to convert it to a string.

Example:

    datetime.datetime(2018, 3, 12, 0, 0)
To this:

    12/03/2018 12:00AM
If I want to convert from datetime object to a string to make it to show 12/03/2018 12:00AM, I would have to use something like this:

    program_stop_date = '20180312000000'
    stop_time = time.strptime(program_stop_date, '%Y%m%d%H%M%S')
    stop_time = datetime.datetime.fromtimestamp(time.mktime(stop_time))
    program_stop_hours = str(stop_time.hour)
    program_stop_minutes = str(stop_time.minute)
    program_stop_days = int(stop_time.day)
    program_stop_months = int(stop_time.month)
    program_stop_year = str(stop_time.year)
    program_stop_hours = int(program_stop_hours)

    if program_stop_minutes == "0":
       program_stop_minutes = "00"
    elif program_stop_minutes == "5":
       program_stop_minutes = "05"

    if program_stop_hours >= 0 and program_stop_hours <= 9:
       program_stop_hours = str(program_stop_hours)
       program_stop_hours = str("0" + program_stop_hours)

    if program_stop_days >= 0 and program_stop_days <= 9:
       program_stop_days = str(program_stop_days)
       program_stop_days = str("0" + program_stop_days)

    if program_stop_months >= 0 and program_stop_months <= 9:
       program_stop_months = str(program_stop_months)
       program_stop_months = str("0" + program_stop_months)
    program_stop_hours = int(program_stop_hours)
    program_stop_days = str(program_stop_days)
    program_stop_months = str(program_stop_months)
                 
                 
    if program_stop_hours >= 00 and program_stop_hours <= 12:
        program_AM_PM = 'AM'
    else:
        program_AM_PM = 'PM'

     program_stop_hours = str(program_stop_hours)
     program_stop_times = str(program_stop_hours + ':' + program_stop_minutes + program_AM_PM)
     program_end_time = str(program_stop_days + "/" + program_stop_months + "/" + program_stop_year + " " + program_stop_times)


Here is what I have stored the datetime in the self.program_end_date list after I have pulled the data from the database:

    cur.execute('SELECT start_date, stop_date, title, program_id FROM programs WHERE program_id=? LIMIT 10', [program_id])
    programs = cur.fetchall()

    for ind, row in enumerate(programs):
        program_stop_date = str(row[1])
        stop_time = time.strptime(program_stop_date, '%Y%m%d%H%M%S')
        program_stop_times = time.strftime('%d/%m/%Y %H:%M%p', stop_time)
        program_stop_time = time.strptime(program_stop_times, '%d/%m/%Y %H:%M%p')
        self.program_end_time = list()
        self.program_end_time.append(program_stop_time)


The reason I want to convert from `datetime` object to a string, is because I want to convert it from a string to `time.struct_time` object like this:

    program_stop_times = '12/03/2018 12:00AM'
    program_stop_time = time.strptime(program_stop_times, '%d/%m/%Y %I:%M%p')



I feel it is not necessary, but I have got no idea how I can convert from datetime to a time.struct_time object. This is the only way I can think of to use the code like I show on the top to convert from datetime to a string and then to time.struct_time.

Can you please show me an example how I can convert from datetime object to a string to make it to show 12/03/2018 12:00AM or use a better way than I could use?

Thanks in advance
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  convert address and broadcast to network object Skaperen 9 1,723 Mar-09-2023, 06:55 PM
Last Post: Skaperen
  Review my code: convert a HTTP date header to a datetime object stevendaprano 1 1,903 Dec-17-2022, 12:24 AM
Last Post: snippsat
  datetime / time ifigazsi 5 7,050 Feb-01-2021, 01:21 AM
Last Post: snippsat
  Assign a value if datetime is in between a particular time limit klllmmm 2 2,699 Jan-02-2021, 07:00 AM
Last Post: klllmmm
  Convert looping home security to a one time scan of switches and sensors duckredbeard 0 1,722 Dec-08-2020, 04:31 AM
Last Post: duckredbeard
  Convert to UTC without changing time pythonlearner1 1 2,071 Nov-05-2020, 09:54 PM
Last Post: pythonlearner1
  How to convert a string "<... object at POINTER>" to an object? mandaxyz 5 3,538 Aug-08-2020, 10:44 PM
Last Post: mandaxyz
  Convert quarterly time series to monthly time series donnertrud 1 5,101 May-22-2020, 10:16 AM
Last Post: pyzyx3qwerty
  datetime object prashantas 1 17,624 Apr-08-2020, 04:58 PM
Last Post: DeaD_EyE
  Convert weekly sequences to date and time. SinPy 0 1,421 Nov-23-2019, 05:20 PM
Last Post: SinPy

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020