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

How to restrict the display of report variants
Hello All,

I want t know how to restrict the display of report variants.
I mean, whe

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

Wordpress IE issue
So I am trying to add the background shadow to my wordpress page. It works fine in Firefox but does

To add a field on the screen XK02.
Hi All,

How to add an additional field in the vendor change control screen XK02.
The

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i

convert PHP array to Javascript array
I have a page that gets a request sent from AJAX, and I am trying to convert a PHP array to a javasc

Can't find the problem (no error message)!
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm g

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie

Change snippet to use CURDATE
I am using time() in the snippet below, I would like to use CURDATE() and have the database setup fo

Calender Not Opening
The following code is not loading the javascript calender in another window. It's not doing anything