Use DATEDIFF()
SELECT DATEDIFF(NOW(),'2006-07-01');
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
Complete list of questions and answers about PHP MySQL. Get prepared for better interview.
Other Interview Sites
Interview Questions Links
- a database name (1)
- advantages and disadvantages? (1)
- and (1)
- and myi? What these files contain? (1)
- and MySQL? (1)
- and windows? (1)
- Answer the questions with the following assumption (1)
- Apache (1)
- Are objects passed by value or by reference? (1)
- but doesn’t for two-dimensional array of mine? (1)
- but it keeps coming up with a different number (1)
- Can we use include ("abc.php") two times in a php page "makeit.php"? (1)
- Can we use include(abc.PHP) two times in a PHP page makeit.PHP”? (1)
- CHECK IF A VARIABLE IS AN INTEGER IN JAVASCRIPT (1)
- crc32() and sha1() crypto on PHP? (1)
- do I get variable substitution inside the heredoc contents? (1)
- ename varchar(10))? (1)
- Explain about Type Juggling in php? (1)
- Explain normalization concept? (1)
- Explain the ternary conditional operator in PHP? (1)
- For printing out strings (1)
- German)? (1)
- give the case where we can use GET and we can use POST methods? (1)
- Give the syntax of GRANT commands? (1)
- Give the syntax of REVOKE commands? (1)
- height) of an image using php image functions? (1)
- How can I embed a java programme in php file and what changes have to be done in php.ini file? (1)
- How can I execute a PHP script using command line? (1)
- How can I know that a variable is a number or not using a JavaScript? (1)
- How can I load data from a text file into a table? (1)
- How can I make a script that can be bilingual (supports English (1)
- How can I retrieve values from one database server and store them in other database server using PHP? (1)
- How can I set a cron and how can I execute it in Unix (1)
- How can I use the COM components in php? (1)
- How can increase the performance of MySQL select query? (1)
- How can we change the data type of a column of a table? (1)
- How can we change the name of a column of a table? (2)
- How can we create a database using PHP and mysql? (1)
- How can we destroy the cookie? (1)
- How can we destroy the session (1)
- How can we encrypt and decrypt a data present in a mysql table using mysql? (1)
- How can we encrypt and decrypt a data presented in a table using MySQL? (1)
- How can we encrypt the username and password using PHP? (1)
- How can we extract string 'abc.com ' from a string http://info at abc.com using regular expression of php? (1)
- How can we extract string "abc.com" from a string "mailto:info AT abc.com?subject=Feedback" using regular expression of PHP? (1)
- How can we find the number of rows in a result set using PHP? (1)
- How can we find the number of rows in a table using MySQL? (1)
- How can we get second of the current time using date function? (1)
- How can we get the properties (size (1)
- How can we increase the execution time of a php script? (1)
- How can we know that a session is started or not? (1)
- How can we know the count/number of elements of an array? (1)
- How can we know the number of days between two given dates using MySQL? (1)
- How can we know the number of days between two given dates using PHP? (1)
- How can we register the variables into a session? (1)
- How can we repair a MySQL table? (1)
- How can we send mail using JavaScript? (1)
- How can we submit a form without a submit button? (1)
- How can we submit form without a submit button? (1)
- How can we submit from without a submit button? (1)
- HOW CAN WE TAKE A BACKUP OF A MYSQL TABLE AND HOW CAN WE RESTORE IT? (1)
- how can we unset the variable of a session? (1)
- How come the code works (1)
- How do I find out the number of parameters passed into function9. ? (1)
- How do you call a constructor for a parent class? (1)
- How do you define a constant? (1)
- How do you pass a variable by value? (1)
- How many values can the SET function of MySQL take? (1)
- How many ways can we get the value of current session id? (2)
- How many ways I can redirect a PHP page? (1)
- How many ways we can give the output to a browser? (1)
- How many ways we can pass the variable through the navigation between the pages? (1)
- How many ways we can retrieve the date in result set of mysql using php? (1)
- How many ways we can we find the current date using MySQL? (1)
- How To Create a Table? (1)
- How To Get the Uploaded File Information in the Receiving Script? (1)
- How To Protect Special Characters in Query String? (1)
- How To Read the Entire File into a Single String? (1)
- How to reset/destroy a cookie (1)
- How to set cookies? (1)
- How to store the uploaded file to the final location? (1)
- How To Turn On the Session Support? (1)
- How To Write the FORM Tag Correctly for Uploading Files? (1)
- I am trying to assign a variable the value of 0123 (1)
- I am writing an application in PHP that outputs a printable version of driving directions. It contains some long sentences (1)
- If the variable $a is equal to 5 and variable $b is equal to character a (1)
- If we login more than one browser windows at the same time with same user and after that we close one window (1)
- IN HOW MANY WAYS WE CAN RETRIEVE DATA IN THE RESULT SET OF MYSQL USING PHP? (1)
- include_once? (1)
- indexes? (1)
- Linux (1)
- List out different arguments in PHP header function? (1)
- myd (1)
- MySQL (1)
- mysql_fetch_object() (2)
- mysql_fetch_row()? (2)
- or a field name in MySQL? (1)
- PHP (1)
- Php) instead of combination of other software programs (1)
- Please give a regular expression (preferably Perl/PREG style) (1)
- print and printf. Explain the differences. (1)
- servers and operating systems? (1)
- So if md5() generates the most secure hash (1)
- Steps for the payment gateway processing? (1)
- the Browser often keeps this page in its cache. (1)
- then is the session is exist to other windows or not? And if yes then why? If no then why? (1)
- there are echo (1)
- there.\nHow are you?\nThanks for visiting fyicenter’; print $str; ?gt; (1)
- Tools used for drawing ER diagrams. (1)
- triggers (1)
- type (1)
- Welcome to Free PHP - MySQL Questions and Answers Blog (1)
- What are encryption functions in PHP? (1)
- What are the advantages and disadvantages of CASCADE STYLE SHEETS? (1)
- What are the advantages of stored procedures (1)
- What are the current versions of Apache (1)
- What are the difference between abstract class and interface? (1)
- What are the differences between DROP a table and TRUNCATE a table? (1)
- What are the differences between GET and POST methods in form submitting (1)
- What are the differences between mysql_fetch_array() (2)
- What are the differences between require and include (1)
- What are the different functions in sorting an array? (1)
- What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2) (1)
- WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP? (1)
- What are the different ways to login to a remote server? Explain the means (1)
- What are the features and advantages of OBJECT ORIENTED PROGRAMMING? (1)
- What are the functions for IMAP? (1)
- What are the MySQL database files stored in system ? (1)
- What are the other commands to know the structure of a table using MySQL commands except EXPLAIN command? (1)
- What are the reasons for selecting LAMP (Linux (1)
- What changes I have to do in php.ini file for file uploading? (1)
- What does a special set of tags do in PHP? (1)
- What Is a Persistent Cookie? (1)
- What Is a Session? (1)
- What is maximum size of a database in mysql? (1)
- What is meant by MIME? (1)
- What is meant by nl2br()? (1)
- What is meant by PEAR in php? (1)
- What is meant by urlencode and urldecode? (1)
- What is the default session time in php and how can I change it? (1)
- What is the difference between $message and $$message? (1)
- What is the difference between CHAR and VARCHAR data types? (1)
- What is the difference between characters \023 and \x23? (1)
- What is the difference between ereg_replace() and eregi_replace()? (1)
- What is the difference between GROUP BY and ORDER BY in SQL? (1)
- What is the difference between htmlentities() and htmlspecialchars()? (1)
- What is the difference between mysql_fetch_object and mysql_fetch_array? (1)
- What is the difference between PHP4 and PHP5? (1)
- What is the difference between Reply-to and Return-path in the headers of a mail function? (1)
- What is the difference between the functions unlink and unset? (1)
- What is the functionality of MD5 function in PHP? (1)
- What is the functionality of the function htmlentities? (1)
- What is the functionality of the function strstr and stristr? (1)
- WHAT IS THE FUNCTIONALITY OF THE FUNCTIONS STRSTR() AND STRISTR()? (1)
- What is the maximum length of a table name (1)
- What is the maximum size of a file that can be uploaded using PHP and how can we change this? (1)
- What is the purpose of the following files having extensions: frm (1)
- What is the use of friend function? (1)
- What type of headers have to be added in the mail function to attach a file? (1)
- What type of inheritance that php supports? (1)
- WHAT TYPES OF IMAGES THAT PHP SUPPORTS? (1)
- What's PHP (1)
- What’s the difference between accessing a class method via -lt and via ::? (1)
- What’s the difference between htmlentities() and htmlspecialchars()? (1)
- What’s the difference between include and require? (1)
- What’s the difference between md5() (1)
- What’s the output of the ucwords function in this example? (1)
- what’s the problem? (1)
- What’s the special meaning of __sleep and __wakeup? (1)
- what’s the value of $$b? (1)
- When are you supposed to use endif to end the conditional statement? (1)
- When viewing an HTML page in a Browser (1)
- When you want to show some part of a text displayed on an HTML page in red font color? What different possibilities are there to do this? What are the advantages/disadvantages of these methods? (1)
- which can be used to identify the URL from within a HTML link tag. (1)
- WHO IS THE FATHER OF PHP AND WHAT IS THE CURRENT VERSION OF PHP AND MYSQL? (1)
- Why doesn’t the following code print the newline properly? lt;?php $str = ‘Hello (1)
- why would you ever use the less secure crc32() and sha1()? (1)
- width (1)
- Will comparison of string "10" and integer 11 work in PHP? (1)
- With a heredoc syntax (1)
- Would I use print "$a dollars" or "{$a} dollars" to print out the amount of dollars in this example? (1)
- Would you initialize your strings with single quotes or double quotes? (1)
- Write a query for the following question (1)
Entertainment Links
| Mobile Fun |
|
Download Free Mobile Phone Ringtones 
|
| Online Games |
 
|
| Free Live Chat Rooms | ||||||||||||
|
No comments:
Post a Comment