7zip: backup com data e hora no nome do arquivo | 7zip with date and time in backup file name

@ECHO OFF

REM DATA E HORA SEPARADA POR PONTO(.)
REM        DIA(DD)     MES(MM)     ANO(AAAA)   HORA(HH)    MINUTO(MM)  SEGUNDO(SS)   
Set TODAY="%DATE:~0,2%.%DATE:~3,2%.%DATE:~-4%" %time:~0,2%.%time:~3,2%.%time:~6,2%
 
ECHO.

REM -mx9 = MAXIMA COMPRESSAO
7za a -tzip "C:\TESTE_%TODAY%.zip" "C:\TESTE" -mx9

ECHO.
 
PAUSE




Postgresql: Backup automático com data e hora no nome do arquivo | Pgdump with date and time in backup file name

Windows!

Crie o arquivo e salve com a extensão .BAT, em seguida faça o agendamento da tarefa no Windows.

// Base local
@ECHO OFF

SET PGPASSWORD=123456

pg_dump.exe -h localhost -U postgres -F c -b -v -f "c:\BackupPostGre_%date:/=%_%time:~0,2%-%time:~3,2%-%time:~6,2%.backup" minhabase

// Base na Amazon
@ECHO OFF

SET PGPASSWORD=123456

pg_dump.exe -h minhabase.xxxx.sa-east-1.rds.amazonaws.com -p 5432 -U postgres -F c -b -v -f "c:\BackupPostGre_%date:/=%_%time:~0,2%-%time:~3,2%-%time:~6,2%.backup" minhabase 

JPA: JPQL count + distinct

Query q = em.createQuery("select "
            + " new com.apalmeira.modelo.followup.Gf( count( distinct p.nome ), u.nome)"
            + " from " + FollowUp.class.getName() + " o"
            + " left join o.pessoa p"
            + " left join o.usuarioResponsavel u"
            + " where"
            + " o.modulo = :modulo and "
            + " o.atividade in (:atividade1, :atividade2, :atividade3) and"
            + " o.mesVigencia between :dataInicio and :dataFim "
            + " group by 2"
            + " order by u.nome");