| Author |
Message |
    
Blazewada
Bewarse Legend
Username: Blazewada
Post Number: 12498
Registered: 08-2008
Posted From: 202.124.30.8
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, October 05, 2010 - 1:19 am: |
|
Black_pearl:SELECT TO_CHAR(sysdate,'DD.MON.RR:HH24:MI:SS AM') FROM dual;
manager idi kaadu, idi rotuine ga chesedi,
just get in to data for a particular table directly in Oracle developer,
say export to insert statements. i dont want to execute any SQL Select statements.
say i have 100000 records, ofocurse i can ru a select query with formatting over the date field, i wanna know how we can do it with direct export.
Prateekaramey Parama Sopanam - Mahabharatham 
|
Black_pearl
Yavvanam Kaatesina Bewarse
Username: Black_pearl
Post Number: 1642
Registered: 05-2010
Posted From: 212.159.240.81
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, October 05, 2010 - 12:45 am: |
|
SELECT TO_CHAR(sysdate,'DD.MON.RR:HH24:MI:SS AM') FROM dual;
UTTHAMA ABHIRUCHI Association Pessident ..
|
Andhramass
Bewarse Legend
Username: Andhramass
Post Number: 39093
Registered: 07-2006
Posted From: 203.26.122.12
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, October 05, 2010 - 12:26 am: |
|
robo database aa?
anni dananallo Annadanam Minna
|
Blazewada
Bewarse Legend
Username: Blazewada
Post Number: 12497
Registered: 08-2008
Posted From: 202.124.30.8
Rating: N/A
Votes: 0 (Vote!) | | Posted on Tuesday, October 05, 2010 - 12:25 am: |
|
DB lo data in Insert statements format lo export chestunappudu, DATE format lo unna vatiki aithey default ga to_timestamp('01-OCT-10','DD-MON-RR HH.MI.SS AM') ani ostondi.
naaku time part antey HH.MI.SS part kooda export avvalantey em cheyyali? column is of type DATE. it stores time part also (Trade Time)
my requirement:
to_timestamp('01-OCT-10 06:29:12 PM','DD-MON-RR HH.MI.SS AM')
Prateekaramey Parama Sopanam - Mahabharatham
|
Archives-2010