104 users online (0 members and 104 guests)  

  Results 1 to 2 of 2


  1. Help with PHP code conversion to PERL    Forum: CGI Perl Forum
    Replies: 0
  2. Mozi to IE conversion codes.    Forum: Myspace Forum
    Replies: 0
  3. conversion articles on google analytics    Forum: Website Promotion Forum
    Replies: 2
  1. #1
    wigiwood's Avatar
    New User

    Join Date
    Aug 2007

    Cool SQL Time Conversion

    I am a newbie to SQL and need some assistance. How can I get the time to display as human time from unix time? I am using Excel to import data from an oracle dataabse. I have included my code below. Its the resolved time line I need to display as human time. Any help is appreciated!

    SELECT a.ticket_id_, a.status,a.case_type, a.TYPE, a.CATEGORY, a.sub_code,
    a.business_unit, a.country, a.site, a.assigned_to_group_,
    a.assigned_to_individual_,a.resolved_time, a.create_time, a.submitted_by, a.SOURCE,
    a.hours_to_resolve, a.total_hold, a.summary, a.solution_text,
    a.root_cause, a.opening_type, a.opening_category, a.opening_sub_code,
    a.priority, a.requester_login_name_, a.submitter_grp
    FROM aradmin.gsk_incident a
    WHERE (a.assigned_to_group_ =
    AND (a.resolved_time BETWEEN 1180656000 AND 1183245839)
    AND (a.case_type < 2)
    AND (a.hours_to_resolve >= 40)

  2. #2
    flann's Avatar
    New User

    Join Date
    May 2007

    Re: SQL Time Conversion

    I'm not sure if this is a mysql database that you're using, but if it is. Look at DATE_FORMAT() for mysql. Every other database should have some sort of date formatting function too.

Tags for this Thread