KyaPoocha.com

Related Interview Questions

• Explain few date functions in VBScript.  21.11.08

  Date(), Time(), Now(), Left(), Right(), & Mid()...

• What are the various attributes in time dimension, If this dimension has to consider only date of birth of a citizen of a country?  20.09.08

  * Date and time (If datetime data type is not supported then you have to have hour/min/sec on a Seperate columns) * Week * Month * Quarter * Year...

• How do I return the last day of the month for the given date ?  21.07.08

  To return the last day of the month for the given date, you can use the LastMonthDay user-defined function. Syntax LastMonthDay (date) Arguments date I...

• How do I return the first day of the month for the given date ?  21.07.08

  To return the first day of the month for the given date, you can use the FirstMonthDay user-defined function. Syntax FirstMonthDay (date) Arguments date...

• What do you mean by NOT NULL WITH DEFAULT ? When will you use it?  20.03.08

  This column cannot have nulls and while insertion, if no value is supplied then it will have zeroes, spaces or date/time depending on whether it is numeric, cha...

• What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP ?  12.03.08

  DATE:              PIC X(10) TIME :              PIC X(08) TIMESTAMP:     PIC X(26)...

• What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?  12.03.08

  DATE:              4bytes TIME:               3bytes TIMESTAMP:     10bytes...

• What are data types?  09.03.08

  They are attributes of columns, literals, and host variables. The data types are SMALLINT, INTEGER, FLOAT, DECIMAL, CHAR, VARCHAR, DATE and TIME....

• Can we change the system date to some other date?  12.03.06

  Yes, We can! The function stime( ) sets the system date to the specified date. It also sets the system time. The time and date is measured in seconds from the 0...

• How do I write code to retrieve current date and time from the system and display it as a string?  12.03.06

  Use time( ) function to get current date and time and then ctime( ) function to display it as a string. This is shown in following code snippet. #include...