Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ss7415
  • Order by date
  1. ss7415

    date time help

    im getting data now. thanks. but can i... for 3/13/2006 11180380 im returning 3/13/2006 11:18:03 AM is there away i can do it like 3/13/2006 11:18:03.80 AM or 3/13/2006 11:18:03.80
  2. ss7415

    date time help

    SELECT TO_CHAR(date_add,'Day, Month DD, YYYY HH24:MI:SS')date_add FROM int_table WHERE ROWNUM = 1 and date_add IS NOT NULL; Wednesday, June 01, 2005 00:00:00
  3. ss7415

    date time help

    the date_add has time but all 12:00:00AM is 20342180 equal to 20:34.2180 (8pm 34 minutes, 21 seconds, 80 hundreds of a second? yes, but would like to keep same format just add : and .
  4. ss7415

    date time help

    yes, but would like to keep same format just add : and .
  5. ss7415

    date time help

    date_add is a date_add = date and time_add = number
  6. ss7415

    date time help

    the date - time should be 4/13/2006 20:34:21.80 first record date_add looks like 4/13/2006 time_add look like 20342180 second record date_add looks like 4/13/2006 time_add look like 20532132 i have date_add and time_add i want combine the two fields . sometimes a record may have the same...
  7. ss7415

    need to combind date and time field

    i have date_add and time_add i want combine the two fields . sometimes a record may have the same date, so i need the time to determine the max. i would like to do it in my command , im using crystal xi and oracle9i the time should be 20:34:21.80 first record date_add looks like 4/13/2006...
  8. ss7415

    combing date and time to do max

    oh damn, im very sorry
  9. ss7415

    combing date and time to do max

    Select @@Version i got ORA-00936: missing expression
  10. ss7415

    combing date and time to do max

    select Max(date_add + + Cast(left(cast(time_add as varchar(8)),2) + ':' + substring (cast(time_add as varchar(8)), 3, 2) + ':' + substring(cast(time_add as varchar(8)), 5, 2) + '.' + right(cast(time_add as varchar(8)), 2) As...
  11. ss7415

    combing date and time to do max

    select max(cast(date_add+ ' ' + left(cast(time_add as varchar(8)),2) + ':' + substring (cast(time_add as varchar(8)), 3, 2) + ':' + substring (cast(time_add as varchar(8)), 5, 2) + ':' + right (cast(time_add as varchar(8)), 2)) as datetime) from int_table im getting an missing keyword error...
  12. ss7415

    combing date and time to do max

    sqlsister's sql gave me a missing keyword error
  13. ss7415

    combing date and time to do max

    seems like its doing the max date time on the entire database, if i can just get the two fields to combind and then i can determine how i want to do the max
  14. ss7415

    combing date and time to do max

    the formating on the time_add isnt that important, i just need to use date_add and time_add to determine min and max
  15. ss7415

    combing date and time to do max

    select max(cast(date_add + ' ' + left(cast(time_add as varchar(8)),2) + ':' + substring (cast(time_add as varchar(8)), 3, 2) + ':' + substring (cast(time_add as varchar(8)), 5, 2) + ':' + right (cast(time_add as varchar(8)), 2)) as datetime) from int_table im getting missing keyword error
  16. ss7415

    combing date and time to do max

    yes it does,sir
  17. ss7415

    combing date and time to do max

    date_add is date time_add is number
  18. ss7415

    combing date and time to do max

    i have date_add and time_add i want combine the two fields and do a max on both combined. sometimes a record may have the same date, so i need the time to determine the max. first record date_add looks like 4/13/2006 time_add look like 20342180 second record date_add looks like 4/13/2006...
  19. ss7415

    need help linking tables please

    actually i need to do more investigation
  20. ss7415

    need help linking tables please

    i am getting alot of duplicats, i want to do the other link (csd_table.sup_ord_nbr = qad_table.wo_nbr) if part is null in the qad table. if it isnt then i want to do part on part

Part and Inventory Search

Back
Top