1 - 6 of 6
PREVIOUS 1 NEXT
SQL Query Issues with date math
Table with partial sample data would appear as follows: EQUIPNO ASSEMBLY START_TIME END_TIME 150 0 24-MAY-09 25-MAY-09 150 0 25-MAY-09 25-MAY-09 150 0 ...
Table with partial sample data would appear as follows: EQUIPNO ASSEMBLY START_TIME END_TIME 150 0 24-MAY-09 25-MAY-09 150 0 25-MAY-09 25-MAY-09 150 0 ...
10 pts.
sql update command to update a date-of-birth
I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR
I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR
Convert date format
How do I convert the given number to date format e.g. 2009062 should result in 03-Mar-2009.
How do I convert the given number to date format e.g. 2009062 should result in 03-Mar-2009.
Converting Julian date to Gregorian in WrkQry
I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)
I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)
iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd
Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...
Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...
Date calculation question
I have a date manipulation question on the AS/400. I need to be able to take whatever date the system date is and calculate the next Friday date and output that to the LDA in the format MMDDYY. It needs to have the leading zero for the single digit months AND it is just a 2-digit year. I swear I...
I have a date manipulation question on the AS/400. I need to be able to take whatever date the system date is and calculate the next Friday date and output that to the LDA in the format MMDDYY. It needs to have the leading zero for the single digit months AND it is just a 2-digit year. I swear I...
1 - 6 of 6
PREVIOUS 1 NEXT
