Showing posts with label Date. Show all posts
Showing posts with label Date. Show all posts

Wednesday, November 28, 2018

Postgres SQL


To get the 12HH with AM/PM

select to_char(create_date at time zone 'utc', 'HH12:MI:SS AM') as "createdate", proc_type, state, * from vb_proc_queue where proc_type='Email1SubsqSignUpNotify' order by create_date desc

04:18:19 PM

Monday, October 31, 2016

Date in Batch File

SET CURRENT_DATE=%date:~4,2%%date:~7,2%%date:~10,4%
>10312016


%date:~10,4%%date:~4,2%%date:~7,2%
>20161031

free online comma separating tool

https://delim.co/#