URL: https://linuxfr.org/forums/linux-debutant/posts/date
Title: date
Authors: zanetti
Date: 2019年08月29日T11:49:22+02:00
License: CC By-SA
Tags: 
Score: 0
Bonjour la famille j'ai un petit problème. J'aimerais que vous me veniez en aide
Fichier.txt à modifier
```sql
---Table call 
CREATE TABLE EPPIX.call_hyb**20180301**_bkp**20180301**
AS
SELECT * FROM EPPIX.call_hyb**20180301**; 
---Table bill 
CREATE TABLE EPPIX.bill_hyb**20180301**_bkp**20180301**
AS
SELECT * FROM EPPIX.bill_hyb**20180301**;
---Table GPRS
CREATE TABLE EPPIX.gprs_hyb**20180301**_bkp**20180301**
AS
SELECT * FROM EPPIX.gprs_hyb**20180301**;
---Table CYCLE
CREATE TABLE EPPIX.cycle**20180301**_bkp**20180301**
AS
SELECT * FROM EPPIX.cycle;
--vider les tables bill , call et GPRS 
TRUNCATE TABLE EPPIX.bill_hyb**20180301**;
TRUNCATE TABLE EPPIX.gprs_hyb**20180301**;
TRUNCATE TABLE EPPIX.call_hyb**20180301**;
---------------------------------------Mise à jour date -----
UPDATE eppix.VSM_SERVICE_MSISDN
SET vsm_billed_upto = TO_DATE(**'2018-02-28','YYYY-MM-DD'**)-- Update here last day of month
WHERE vsm_subscriber_id IN(
 Select distinct sbd_subscriber_id from eppix.sbd_sub_dets ,vas_active_service vas
 Where vas_subscriber_id =sbd_subscriber_id
 and sbd_bill_cycle='HYB'
 and vas_sub_charge1 is not null
 and vas_sub_charge1 != ' '); 
commit;
----------------------------------------Mise à jour service SPD
update vas_active_service set vas_sub_charge1=vas_service_code where vas_service_code like 'SPD%' and vas_service_code!=vas_sub_charge1 
commit;
```
et voici mon script qui me permet de le modifier
```sh
#!/bin/sh
datejour=`YYYYMM01`
datemoisprecedent=`YYYY-MM-JJ`
Datedudernierjourdumoisprecedent =$(date --date "today - $(date +%d) days" +%Y-%m-%d) 
Datedupremierjourdumoisencours =$(date +%Y%m01)
sed -i 's/'$datejour'/'$Datedupremierjourdumoisencours'/g' hyb.txt;
sed -i 's/'$datemoisprecedent'/'$Datedudernierjourdumoisprecedent'/g' hyb.txt;
```
J'aimerai changer les dates de mon fichier.txt sans avoir à figer mes dates. Lorsque j'exécute mon script il m'affcihe des erreurs de ce genre :
- ./maj.sh:line 3: YYYYMM01 : commande introuvable
- ./maj.sh: line 4: YYYY-MM-JJ : commande introuvable
sed: -e expression n°1, caratère 0: pas d'expression régulière précédente
Merci d'avance.
Cordialement;
</div><div class="naked_ctrl">
<form action="/index.cgi/contrast" method="get" name="gate">
<p><a href="http://altstyle.alfasado.net">AltStyle</a> によって変換されたページ <a href="https://linuxfr.org/forums/linux-debutant/posts/date.md">(-&gt;オリジナル)</a>
/ <label>アドレス: <input type="text" name="naked_post_url" value="https://linuxfr.org/forums/linux-debutant/posts/date.md" size="22" /></label> <label>モード: <select name="naked_post_mode">
<option value="default">デフォルト</option>
<option value="speech">音声ブラウザ</option>
<option value="ruby">ルビ付き</option>
<option value="contrast" selected="selected">配色反転</option>
<option value="larger-text">文字拡大</option>
<option value="mobile">モバイル</option>
</select>
<input type="submit" value="表示" />
</p>
</form>
</div>