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 .
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...
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...
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
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.