Skip to main content

[Powershell]: Get-Date and commonly used date format

Get-Date and commonly used date format in powershell


PS C:\Users\Administrator> get-date
Thursday, June 25, 2015 9:42:24 AM

PS C:\Users\Administrator> $today = get-date
PS C:\Users\Administrator> echo $today

Thursday, June 25, 2015 9:43:21 AM

PS C:\Users\Administrator> $todayshort = get-date -format yyMMdd
PS C:\Users\Administrator> echo $todayshort
150625

PS C:\Users\Administrator> $todaylong = get-date -format yyyyMMdd
PS C:\Users\Administrator> echo $todaylong
20150625

PS C:\Users\Administrator>

Popular posts from this blog

Red Hat Enterprise Linux Developer Subscription

subscription-manager register subscription-manager subscribe subscription-manager list subscription-manager repos --list-enabled
Read more

How to charge your device from USB Port

First of all, check BIOS Settings of your laptop or desktop Dell Look for USB PowerShare BIOS Settings: USB PowerShare Lenovo Look for Always On USB Charge in Off Mode BIOS Settings: Enable Always On USB Charge in Off Mode
Read more

MySQL: Notes

Ways to check MySQL version mysql --version mysql -V dpkg -l 'mysql-sever' mysql -u root -p How to check MySQL version: mysql --version Database folder On Microsoft Windows, by default, MySQL save databases in this folder: %ProgramData%\MySQL\MySQL Server 5.5\data Check databases' size SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema; Export database schema $ mysqldump -u root -p --no-data wordpress1001 > c:\backup\schema-wordpress1001.sql Enter password: **************** Create a dedicated user to backup databases Give credit to: http://www.fromdual.com/privileges-of-mysql-backup-user-for-mysqldump Create dedicated mysql user and grant privileges to run backup $ mysql -u root -p CREATE USER 'backupdb'@'localhost' IDENTIFIED BY 'passwordhere'; GRANT SELECT,SHOW VIEW,RELOAD,REPLICATION CLIENT...
Read more