Recent content by ss7415

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

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

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 .

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

date_add is a date_add = date and time_add = number

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...

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...

oh damn, im very sorry

Select @@Version i got ORA-00936: missing expression

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...

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...

sqlsister's sql gave me a missing keyword error

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

the formating on the time_add isnt that important, i just need to use date_add and time_add to determine min and 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