37 users online (1 members and 36 guests)  


  Results 1 to 2 of 2

Related

  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

    Status
    Offline
    Join Date
    Aug 2007
    Posts
    1

    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_ =
    ANY ('PCS-JANITOR-QUOTA',
    'PCS-MESSAGING-NOTES-GBL',
    'PCS-MESSAGING-NOTES-UK',
    'PCS-MESSAGING-NOTES-US',
    'PCS-MESSAGING-EXTERNAL-SRVCS')
    )
    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

    Status
    Offline
    Join Date
    May 2007
    Posts
    18

    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