That returns timestamp corresponding to 19:00PM
For example:
*long* myTimeAsLong=1542326400000L; // from NiFi
DateFormat sdf = *new* SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
System.*out*.println(sdf.format(*new* Date(myTimeAsLong)));
prints out 2018/11/15 19:00:00
On Wed, Nov 14, 2018 at 9:21 AM Mark Payne <[email protected]> wrote:
> You should be able to do something like:
>
> ${now():divide( 86400000 ):multiply( 86400000)}
>
> I.e., use integer division to divide by number of milliseconds in a day,
> which gives you
> the number of days since epoch. Then multiply by 86,400,000 again to
> convert from
> days back to milliseconds. While it looks immediately like it would do
> nothing, the thing
> to keep in mind is that the divide() function performs and Integer
> Division operation,
> not a Decimal Division, so all decimals would be dropped, which
> essentially results in
> all hours/mins/seconds/milliseconds getting dropped.
>
> Thanks
> -Mark
>
>
> > On Nov 14, 2018, at 9:01 AM, l vic <[email protected]> wrote:
> >
> > I have to retrieve "today's" records in ExecuteSQL, eg. with the query
> using timestamp "ts" column in table where ts type is "epoch" time as long
> integer :
> > select * from mytable where ts >= midnight-timestamp-value
> > Any idea how i can use "now()" function to get today's timestamp value
> at midnight?
> > Thank you,
>
>
