how will be date change into string
Answers were Sorted based on User's Feedback
Answer / sudipta santra
to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / rajgopal
select to_char(sysdate,'ddsp')||'-'||to_char(sysdate,'mon')||'-'||to_char(sysdate,'yyyysp') from dual
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain the rollback statement?
Can you do multiple joins in sql?
What are tuples in sql?
how can we repair a mysql table? : Sql dba
Explain unique key in sql.
Is there a 64 bit version of ssms?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Can you join a table to itself?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
what are properties of a transaction? : Sql dba
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
Explain foreign key in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)