how will be date change into string

Answer Posted / sudipta santra

to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by pl/sql cursors?

739


what are the differences between char and varchar? : Sql dba

748


what is a trigger in mysql? : Sql dba

785


Is postgresql a nosql database?

791


how to enter numeric values as hex numbers? : Sql dba

770






How do I order by ascending in sql?

741


What is the mutating table and constraining table?

738


How do I find duplicates in the same column?

733


Can a foreign key be null?

809


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1079


What is snowflake sql?

799


Explain unique key in sql.

738


What are the rules to be applied to nulls whilst doing comparisons?

983


how many ways to get the current time? : Sql dba

708


Explain spool.

903