Help on query replacing the date

Posted on 16th Feb 2014 07:03 pm by admin

Hi Pals,

i want to replace the current date in a column to some value say C or D or any numeric value , likewise the NVL function which replaces the null value can i replace value selected to my assigned value
eg

select * from employee where employeedate= current dat will display the dates as 2008-10-10 to C or D

Your Answer:

Login to answer

Other forums

Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';
and ha

New Login Script
Hi all, i attempted to create a whole new login script witch isnt working for some reason i dont kno

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

SQL Query/echo not working
Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I h

Matchcode in ALV change header column
Hello everyone,

I am working in an SAP system that is currently in upgrade and conversion

undefined offset help
Hi All,

I kept getting undefined offset PHP notice for a simple for loop. For eg
$va = arr

Problem with coding MySQL query
I'm having heaps of trouble getting one of my PHP/MySQL queries to work for some reason (and the fun

remove innitial

and

tags
i am using tiny_mce as a text editor for my CMS.
buy now the problem is it add <p>

Progress bar for webpage
Hi,
I want to implement a progress/waiting bar on my webpage - exactly the same thing that the Mi

PHP switch function help
Hi, I am trying to create a search function for a directory website. On the search function on html