jeff post
post by jeff
Langara Information Technology
post by jeff
Crane was built this week.
These photos are taken every 10 minutes
This link saved my bacon today.
https://www.macobserver.com/tmo/article/see_full_cookie_details_in_safari_5.1
Video File URL, fileThe URL of the video. This can be a YouTube video, or can be hosted on Langara’s myMedia server
e.g. https://mymedia.langara.bc.ca/vod/kins2284/kins2284_adolescen1_female_14yrs_runner_lateral_nov_2012.m4v
Image File URL, imageThis is the image that will appear on the video player when the page loads. Think of it as a splash image for the video.
e.g.: https://mymedia.langara.bc.ca/vod/kins2284/kins2284_adolescen1_female_14yrs_runner_lateral_nov_2012.m4v
Width and Height You can customize the size of the rectangle that appears on the page.
See the official README file
I needed to find a way to always select the date range of the previous month.
So if it’s January, I need to select rows with dates between Dec 1 and Dec 31 of the previous year.
If it’s February, I need to select dates with Jan 1 and Jan 31 of the previous year.
Here’s how to do it:
select
trunc(trunc(sysdate, ‘MM’) – 1, ‘MM’),
to_char(trunc(trunc(sysdate, ‘MM’) – 1, ‘MM’),’DD-MON-YYYY’) “First Day of Last Month”,
trunc(trunc(sysdate, ‘MM’) – 1),
to_char(trunc(sysdate, ‘MM’) – 1,’DD-MON-YYYY’) “Last Day of Last Month”
from dual ;
Here’s a state diagram shows how complicated it really is:
Image by Andrew Durdin