select instrid, instrname, rownum from instrument order by instrid select to_char(startime, 'hh:mi') stime, to_char(endtime, 'hh:miAM') etime, NVL(username, 'X') username, to_char(startime, 'hh:miam') stime2 from ulog_vu where (startime between sysdate-1/24 and sysdate+23/24) and instrid = '#getInstr.instrid#' order by startime NMR Instrument Sign Up Sheet
Emory Uniuversity NMR Research Center
INSTRUMENT SIGN-UP DISPLAY
Current Time: #date1#, #time1# (24 Hour Data)
Home - User List - User Policy - Sign Up Now - News
#getInstr.instrname#
select to_char(startime, 'hh:mi') stime, to_char(endtime, 'hh:miAM') etime, NVL(username, 'X') username, to_char(startime, 'hh:miam') stime2 from ulog_vu where (startime between sysdate-1/24 and sysdate+23/24) and instrid = '#getInstr.instrid#' order by startime
#stime#-#etime# #username# (#stime2#)