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

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Problem with PHP code- simple contact form
Hi Folks,
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a co

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

replacements
I have a variable in my PHP script like

ASSFDDDDDDDDDDDDDASDDDDDDDDARYTRHKKHHHHHHHHHHH and p

How to pass parameter to tag query?
Hi,
I want to get the value of a tag at a specific time (like 10/27/09 15:29:59), I need to giv

Login logout link help
Hi all,

Im new to php and Im having trouble creating a login/logout link for my page that dis

SAP Treasury - Commodities
We are running SAP ECC 6.0 with Treasury Activated.
EA-FIN is also activated (SFW5).