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

PHP Directory Listing Not working
Hey Guys,

I need help, I tried a ton of directory listing scripts and they all don't work. Al

duplicate record notification
In my database, after insertion of records, I want to know if the record inserted is duplicate or no

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

Grids not displaying decimals, and behaving differently on different PCs?
Hello,

I coded a relatively simple MII application that allows data from a form to be add

Undefined Index Notice In Internet Explorer Only
I am getting the following notice:

QuoteNotice: Undefined index: jrox in /home/ycsn/public_h

The type or namespace name 'ServiceModel' does not exist in the namespace 'System'
When I locally run the website, it works just fine, but when I uploaded it to the hosting environmen

how to read and write into a word document using php...?
hi,
I need,reading and writting into a word document using php.




Thank u inadva

This must be easy , pulling the last record of the day, every day, from a txt
I have a txt file logging weather data every minutes (so 1 record per minute). I want to extract the

rename the file
File.txt

Code: ***DOCUMENT***
..DN:
000044255
..CB:
..SN:
..PY:
2009
..E