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 code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat

if description does not contain the following words
Hello everyone,

I am parsing a MS Excel (.xls) file and adding it's content to a mySQL databa

How to use Substr
I want to check for the word CATEGORY: inside a string which can be CATEGORY: ITEM
and remove the

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

DOMDocument
Hello All,

I need to take an XML document, modify some of the nodes in it and then perform a

Gaining access to Drop Down Menu Variable
code is below, I am creating a drop down menu. I want to echo the value selected in the drop down me

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :