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

Stuck with preg_replace
Hi,

I'm trying to use preg_replace to remove part of the IP address submitted using a form on

animation progress while uploading files?
Hello, i have some website form to upload few files to server. i want to put some gif animation whi

ALV sum various columns problem
Hi all,
I'm doing a report on ABAP for a timesheet of the current month. The output i want is s

Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then

Multithreading design
Hi

I have come up with a Singleton class that manages a pool of database connections. Basical

Values disappear from my array :( HELP!
hey all, I have a lil mysql/php/apache script that queries a database
and pulls put 5 integers.

Day of week
I am using PHP version 5.0.5
I have a varaible ($DATE (date format yyyy-mm-dd)) that is being inc

RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai

Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this

('date' => '20

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil