Answer / praveen

select to_date('Column_Name','dd-mon-yyyy') from table_name;

Answer / pulakesh

select * from testdate
where to_date(column1,'dd-mon-yyyy')=to_date(column1,'dd-
mon-yyyy') and length(column1)>8

Answer / dipti

select * from TABLE1
where VSIZE(column_name) > (select VSIZE('DD-MON-YYYY') from dual)

Answer / kumar

select * from employees
where
length(hire_date)=length(sysdate)

Answer / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

Answer / sowmya

Select date from table where date:=to_date(‘date’,’DD-MM-
YYYY’);

What is data profiling in sql?

0 Answers  

What is a sql statement?

0 Answers  

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

What is left inner join in sql?

0 Answers  

What is execution plan in sql?

0 Answers  

what is index? : Sql dba

0 Answers  

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

What is sql profiling in oracle?

0 Answers  

Hi Everyone, How to get fist and last record from a table in oracle? Thanks in advance

13 Answers   IBM,

What is the purpose of the primary key?

0 Answers  

What is left join in sql?

0 Answers  

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers