Ubuntu sound not working after sleep/suspend

Question

I would like to ask how do i check if the difference between two dates.

1. BillingDate which is a date type with an entry 'DD-MON-YYYY'

2. and the other date is the current date.

sys_date - BillingDate = daysFromBilled

alot of the examples i find they actually stated the second date to calculate the difference but what i am looking for is the difference between the current date so i can add it into a schedule or job.

i am using oracle btw.

---

Another point to add, i will continue to search, but if your could also recommend, how should i implement such a function:

1. Calculate date difference from all BillingDate entries
2. To trigger an alter table if the difference is more than 30 days to put Status as Late.
3. If Status is more than 60 days the Service attribute will be altered and changed to Cut

here is my rough table layout

Cust             Billing
--------         ----------
CustID(PK)       BillingID(PK)
LateStatus       LateStatus
Service          BillingDate
                 CustID

Thanks alot.

Update

REPLACE view DateDifference as select trunc(sysdate)- trunc(BillingDate) from Billing;

seems legit.

Solution

I just installed pavucontrol and things started working. Checkout this qa

Comments

[a_horse_with_no_name]

An "alter table" is used to change the definition of a table (e.g. add or remove columns). You want to UPDATE the table, not "alter" it.

[hba]

I'm running into the same problem on mint17

[Jan Henke]

Can you post the output of aplay -l from when it happens here? Sounds like the audio device is not properly reactivated after sleep.

[Hastur]

Many question and answer about this topic on our sister-sites. You can start a search e.g. from "no sound after suspend/resume" or from "Ubuntu 16.04 changes sound device after suspend, how to fix?" on askubuntu...

[Chris Pin]

thanks for your reply, i understand the remarks about the update and alter table . i apologise if i ask stupid questions and statements, i am getting familiar with sql. do you think you could show me an example of how you would write the syntax for the difference in days question.

[a_horse_with_no_name]

@ChrisPin: I showed you how to calculate the difference in days.

[a_horse_with_no_name]

@ChrisPin: Don't post code in comments, edit your question. And please read the Oracle manual regarding variable assignments in PL/SQL: docs.oracle.com/cd/E11882_01/appdev.112/e25519/… See my edit for a short example.

[Chris Pin]

thanks a_horse_with_no_name I really appreciate your help. thanks alot for the link too.

[Adriano Martins]

You should avoid adding new answers if the question already has an accepted answer and you do not add any new piece of information (which where not present on the previous answers).