Oracle DB Timestamp edit:
715829Aug 5 2009 — edited Aug 14 2009I have a database with about 60,000 pdf/word files. When they were entered they got timestamped: date and time. what I'm using them for only uses the date. I've hardcoded it to just put the date now when adding to the database. I want to go in and edit all of the other ones to delete the time. I believe this can be done by using a SQL query but im new at this. looking for a shove in the right direction.
would either of these do the trick?
alter table (pdfTable) modify (timeStampCol) date
MODIFY "timeStampCol" "DATE"
My thinking, and what I'm understanding from the textbook is that if we change the format of the date attribute held in the table we will therefore rid it of the time part. is this correct?
cheers!