text:
Rooms With a View (and How Much You'll Pay for Them)
By: Caroline Biggs VIEWED 86 TIMES
Published: 5/10/2019Source: The New York Times
Featuring Spencer Cutler and Nicholas Athanail's listing at 450 West 17th Street, Chelsea, Michael Gordon's listing at 30 Park Place, Tribeca, and Paul Kolbusz and Fred Hong's listing at 130 West 12th Street, Greenwich Village:
Not all New York City views are created equal.
Direct Central Park views may be the most valuable amenity in Manhattan real estate, but in a market filled with soaring new developments — some of which wind up blocking the views of other buildings — even a partial glimpse of a river, park or the city skyline can also command a hefty premium.
To get a sense of how much people are willing to pay for the city's most sought-after views, Jonathan Miller, the president of the appraisal firm Miller Samuel, looked at several buildings that have stunning vistas and compared the sale prices of apartments with similar layouts in each building — those with views and those without.
New Yorkers, he discovered, are generally willing to pay 10 to 25 percent more for an apartment that allows them to wander over to the window and take in the sights — whether that's a boat moving up the river or the rolling lawns of Central Park.
Mr. Miller calculated a rough percentage of an apartment's value that could be attributed solely to the view by winnowing out the other surcharges that might affect a property's value, like a floor-level premium, which Mr. Miller said ran "about 1 percent for every floor you go up." (In other words, all other things being equal, apartments along the same line typically increase in value at about 1 percent per floor.)
He also found that two apartments of different sizes but with the same view command the same premium. "The dollar amount may differ, but the percentage of the property value associated with the view remains the same," he said.
Mr. Miller's research suggests that the most costly views are in buildings where there is no possibility of having those views obstructed — like a view of Central Park that can't be lost because the building is right on the park. He also found that park-view premiums run higher than those for river views, but that expansive vistas of the city are valued just about the same as limited or narrow views of Central Park.
"Even complete views above the 50th floor of a super-tall building are not guaranteed in this town, because the skyline is always changing," Mr. Miller said. "Helicopter views can be partially interrupted by another super-tall building across the street."
Thirteen years ago, when Jerry Bovino and his wife, Ester, bought a seven-room co-op directly on Central Park, at 875 Fifth Avenue, it was the view that sold them.
"The very first thing I did was walk to the window," said Dr. Bovino, a retired retina surgeon who also has homes in South Florida and Aspen, Colo. "I took one look at the view and said, 'I'll take it.'"
While many apartments along Fifth Avenue have only two exposures (east and west), the Bovinos' 18th-floor co-op offers 270-degree views to the west, south and east — including dramatic above-the-tree views of Central Park from the living room and bedrooms.
Now that he and his wife, a real estate and mortgage broker, have retired, Dr. Bovino is selling the co-op, so they can move closer to their grandchildren in Colorado. The asking price is $11.5 million.
"Some New Yorkers are willing to sacrifice good views for square footage," Dr. Bovino said. "But with these kind of views, you're bringing the outdoors in and creating the illusion of more space."
It should be no surprise that a front-row seat at Central Park commands a hefty premium. After comparing the closing price of Dr. Bovino's 2,000-square-foot co-op in 2006 with two other sales in the building — one measuring 2,400 square feet and facing the park that sold for $11.5 million and the other measuring 1,700 square feet but with rear views of rooftops and a partially obstructed cityscape that sold for $4.2 million — Mr. Miller determined that park views in the building came at a 25 percent premium.
"Water views tend to command the highest premium everywhere else," Mr. Miller said. "I like to quip, 'Manhattanites are inward-looking, because we place a premium on a Central Park view versus a river view.'"
Across the park, Teresa Sommers has dreamy, direct tree views of Central Park from the casement windows in the living room and the master suite of her third-floor Classic Six on Central Park West. Ms. Sommers and her family have put the apartment on the market for $4.495 million, because the children are grown and have moved elsewhere.
"It makes you feel like you're in the trees," she said. "Just to be able to have some of outdoors inside is valuable in itself."
How valuable exactly? Mr. Miller compared the sale price of Ms. Sommers's condo in 1991 with that of a unit in the northwest corner of the building that does not face the park, but that clears the roofline of the buildings across the street, and he concluded that a tree-line view of Central Park in that building comes with a 20 percent premium.
"Virtually no view is guaranteed, so perhaps the Central Park premium is worth more than any other view in the city, because it is unlikely that it would change in our lifetime," Mr. Miller said. "Even river views can be obstructed."
While you may not ever lose a front-and-center view of Central Park, other properties that face the park a few blocks away may not be so lucky.
At One57, a 6,200-square-foot penthouse fills the entire 87th floor of the 90-story building. Designed with walls of glass in most rooms, the condo offers panoramic views of Central Park, the downtown skyline, and the East and Hudson Rivers. But the building is still on West 57th Street, while the southern boundary of the park is West 59th.
"One of the biggest challenges when looking at the premiums for Central Park is that most buildings being built now are taller and positioned closer to the park, obstructing views from older buildings," Mr. Miller said. "So taller buildings drive a higher premium."
In the case of 157 West 57th Street, Unit 87, currently listed for $58.5 million, Mr. Miller estimated that a buyer will pay a 25 percent premium for those soaring views, compared to what it would cost to buy an apartment on a lower floor. As he noted, "360-degree views don't exist on lower floors. The views can still be expansive, but often they're more obstructed."
New Yorkers' preference for a park view apparently extends beyond its iconic park.
Chris and Mary Ann Lotito have views in every direction from their 20th-floor apartment in the Caledonia, one of the first luxury buildings built along the High Line. Designed with floor-to-ceiling windows throughout the entire condo, the 21-foot-long great room has south, east and west exposures offering views of the Hudson River, the downtown skyline and the park below. The building is just two blocks from the Hudson River.
"You get the best of both worlds in the same room," said Mr. Lotito, owner of Lotito Foods, a food importing and manufacturing business based in New Jersey. "The pulse of the cityscape and the tranquillity of the barges and boats going up and down the water."
To determine which is more valuable, a view of the High Line or of the Hudson River, Mr. Miller compared the price Mr. Lotito paid for his condo with one in the same building with river-facing views (and none of the High Line). He found a 10 percent High Line-over-Hudson premium, supporting his theory that Manhattan homeowners are "inward-looking."
"When the High Line was built, new developments started popping up," Mr. Miller said. "So this could prove to be a short-term statistic since, unlike direct views of Central Park, these views change over time."
Now that they are retiring, the Lotitos have listed their condo for $4.895 million, and are also selling their home in New Jersey, so they can buy a larger property in the same area of Manhattan, with similar views.
"We're going big for retirement," Mr. Lotito said. "We want double the space and the good views."
A Tree-Lined Street
But in the concrete jungle, where access to expansive greenery is valuable and rare, how do views of gardens compare with those of the cityscape and the skyline on a higher floor?
On a quiet block on West 12th Street, Colyer and Kate Curtis have south-facing views of large trees and gardens — in the backyards of townhomes across the street — from every room of their third-floor condo in a 13-story prewar building.
"It feels likes an oasis in the middle of New York City," Ms. Curtis said. "The views of the gardens and trees create a sense of calm and quiet that is so precious in this city."
The Curtises listed the condo for $3.55 million after buying a larger apartment for their growing family in the same building, a few floors up, with views of treetops and some of the cityscape.
Looking at sale prices in the building over the past decade, Mr. Miller discovered that while soothing treetop views command a certain price, they come at a 15 percent discount when compared to the prices of apartments on higher floors with open city views.
"From a marketability standpoint, having views of greenery is valuable — but still not as valuable as one from higher levels," he said.
"It also implies that there's an exclusivity of greenery in parks," he added. "A tree outside your window doesn't have the same permanence as a park across the street, and that's where the value premium lies."
After falling in love with views of the river and skyline from his 52nd-floor condo at 30 Park Place in the financial district, Mark Mohrmann was perturbed when a new development partially obstructed those views.
His two-bedroom spread at the Four Seasons Private Residences initially offered somewhat limited views of the East River and the Brooklyn Bridge, as well as views of the Hudson River and downtown skyline — but then 25 Park Row popped up next door. While the condo's southern exposure still has a view of the Hudson River and the downtown skyline, the new building looms large in the vista to the east.
Mr. Miller estimated that an apartment on a higher floor with nearly unobstructed views of the water and downtown skyline came at a 25 percent premium when compared to a condo with obstructed city views on a lower level.
For Dr. Mohrmann, an orthopedic surgeon who owns Five and Dime, a coffee and cocktail bar in the neighborhood, and his wife, Alexandra, that was the push they needed to find a new place for their family.
"With our new family, my wife and I wanted to provide our kids with more room to grow, better views of the river and easier access to the Seaport," Dr. Mohrmann said. "This inspired us to look for a bigger property that was closer to the water."
The Mohrmanns put their condo on the market for $4.525 million and have bought a new condo a few blocks away, at 130 William Street. From their 49th-floor unit, the family can take in expansive, unobstructed views of the downtown skyline, the East River and Hudson harbor, because the building is closer to the water.
They also bought one of five available private cabanas on the building's rooftop, which has 270-degree views of the water and the Statue of Liberty.
After analyzing the sale price of the Mohrmanns' new condo with that of one on a lower floor with partially obstructed skyline views, Mr. Miller determined that the spectacular water views came at a 25 percent premium.
"You can move the same apartment on Central Park and sit it on top of one of these towering buildings with expansive views of the harbor, and it starts to be about the same premium," he said.
"It all comes down to marketability, because every view premium an apartment enjoys is based on the apartments it competes with," he added. "Even for the best of the best."
Copyright © 2019 The New York Times Company. Reprinted with Permission. Stefano Ukmar/The New York Times.
Please click here to read the article on nytimes.com
RETURN TO PRESS PAGE
130 West 12th Street, Apt. 3C
October 10, 2019WeWork Founder Adam Neumann's Trove of Pricey Properties
August 16, 2019What $1.5M buys in NYC right now


Calacatta Bella Collection in Floor Covering Weekly | Marble System Inc.
Posted on February 1, 2019 at 2:33 pm.
Thanks to Floor Coverings Weekly for featuring our new Calacatta Bella Collection as featured product of the week. Our Calacatta Bella Collection is a beautiful white marble with hues of grey flowing through this spectacular natural stone. This collection conveys the essence of Calacatta marble with its bold veining. Available in polished tiles, mosaics and moldings, Calacatta Bella Collection is a perfect choice for an elegant and timeless look for any interior wall or floor application.


Spanish state visit (July 2017). Photo: Foreign and Commonwealth Office (CC BY 2.0).
With an index value of 204.1 points, Spain ranks 12th (out of 100 countries) in the latest edition of Elcano Global Presence Index –that assesses countries according to their external projection in the economic, strategic and cultural and social spheres–. Spain has considerably increased its global presence between 1990 and 2016, due to its fast insertion in the global economic, social and political arena at the beginning of this period (through, for instance, its adherence to the EU or NATO). Spain's external action has turned more economic throughout these years. Starting with a strong soft profile of projection, the country ranks now 12th in the economic dimension, 11th in the soft domain but falls to the 17th position in the military realm.
Spain is also, mainly, a European international player. As shown in a previous report, it is the sixth contributor to EU's global presence –that is, the external projection of the Union as if it behaved like a single political actor–. This European 'bias' also appears in the international allocation of Spanish global presence. Over 61% of such presence is projected in European countries. Latin America comes second (less than 14%), followed by North America (8%), Maghreb and the Middle East and Asia and the Pacific (7% each) and, lastly, Sub-Saharan Africa (slightly less than 3%). More specifically, the share of global presence projected in the United Kingdom equals that of the whole Latin American region (Graph 1).
Graph 1. International allocation of Spanish global presence (2016; as a % of total global presence). Source: Elcano Global Presence Index.
The United Kingdom is a relevant partner for Spain in almost all fields of international relations. Moreover, this partnership has slightly strengthened over the last decade as the share of global presence to the United Kingdom has increased from 12.7% in 2005 to 13.5% in 2016.
As shown in Table 1, this country is the first destination of Spanish economic and soft dimensions, and has recently fell to the second position in the military dimension. The United Kingdom hosts the largest stock of Spanish foreign direct investment and buys the largest amount of Spanish tradable services. It is also the first country of origin of tourists to Spain. It is the second international destination of Spanish troops (and consequently of military capacities); the country of origin of the second largest community of immigrants in Spain; the second destination of exports of cultural services; and the second partner in scientific global activity. The fact that it is also the third market of exports for Spanish manufactures indicates that both countries belong to a same regional production chain (something that is also shown by the strong similarities between the exports and imports baskets in bilateral trade). When it comes to primary goods (one important feature of Spain's external projection), United Kingdom is this country's fifth partner.
Source: Elcano Global Presence Index.
The current methodology of the Elcano Global Presence Index does not allow for the calculation of the British presence in Spain (United Kingdom's global presence cannot be broken down by destination). However, there are two features of British global presence that may indicate that Spain is not such an important host of United Kingdom's external projection as it happens the opposite way.
Firstly, it is well known that the United Kingdom is a major global player. The country has the fifth largest world economy (according to World Bank figures) and ranks fourth, with an index value of 565.6 points, in the Elcano Global Presence Index. Such external projection is relevant in almost all fields. The country is fourth in the economic dimension (third world investor abroad), fifth in the military domain and jumps to the second position in the soft dimension (mainly due to its performance in sports, culture, science, education and development cooperation). Therefore, it is very likely that such global presence is diversified in a number of countries.
Secondly, Elcano Global Presence Index results for the United Kingdom show what we have previously defined as the 'British paradox'. This country is the first contributor the European Union's external projection; a fact that may seem counter-intuitive given the relatively lower profile of the United Kingdom (when compared with Germany or France) in the construction of the European project. However, this is precisely the reason why the British society is the greatest contributor to the projection of the EU outside its borders: its global presence is probably not as intra-European as that of Spain, and as that of big European players like Germany or France.
In short, United Kingdom and Spain hold a thick bilateral link in all domains, that has strengthened during the last decade. Although the share of British presence in Spain is unknown (for now), and is presumably not as high as that of the Spanish presence in the United Kingdom, the Elcano Global Presence Index results show the co-dependence of these two countries particularly in the economic and soft dimensions.


Bed Bugs at the Travelodge scare this family over holiday weekend vacation.
WILLIAMSBURG, Va. — A mother said her children were now scared to go to sleep after the family stayed at a Williamsburg motel. During their recent stay, Elizabeth Wilcox said she discovered bed bugs in the motel room after she noticed rashes and bites on her children.
The manager of the Travelodge, off Richmond Road in Williamsburg, said the property did not have a bed bug problem and found no issues when he inspected the room. He said he would order a pest control company to inspect the room.


text:
Q: send large files over socket java I am trying to transfer larger files over socket.I will be transferring the file in chunks.As shown in the code.link
int count;
byte[] buffer = new byte[8192];
while ((count = in.read(buffer)) > 0)
{
  out.write(buffer, 0, count);
}

before sending this file,i want to send an object which holds the details of the file.Using which stream should i send Object + File.
I am new to streams,can i get any sample code.
Can i send the byte length of the object first to read the object ,save it and send file data.is it possible,any sample code ?
Thanks
421

A: I'm not sure whether using Java's serialization mechanism is the best way to do a simple file transfer. As your question suggest, you try to avoid keeping the whole file in memory at any time. This can be done with objects using the Proxy pattern but if all you want to do is transfer the file, this might not be the most straight-forward solution. (Also, it will effectively tie your peer to be implemented in Java too.)
Instead, why not take a look at an extremely successful protocol that does exactly what you need: HTTP.
Content-Type: application/octet-stream
Content-Length: 542183

542183 bytes of data follow...

It should not be too hard for you to write a parser for the meta-data header.

A: You need to ensure the order of writing/reading. If write an object -> write raw bytes on client, then read an object -> read raw bytes on server. When reading, ObjectInputStream should be able to find the boundary of the serialized object data.
If you want to keep a socket connection long-live and use its streams multiple times, wrapping socket's Output/InputStream in a ObjectOutput/InputStream is not a good idea IMO. When you close a object stream, it closes the underlying stream as well.
So you may want to write the length of serialized object data first (file length is contained in the object so you don't need to write it explictly), e.g. 4 bytes of BigEndian encoded int. Then serialize the object into a ByteArrayOutputStream, and write the bytes in its buffer. On the server, read 4 bytes first, decode the bytes back to an int, and read that many bytes into a byte[], wrap the byte array with a ByteArrayInputStream and deserialize the object from it.
Write like this:
......
OutputStream out = socket.getOutputStream();

ByteArrayOutputStream baos = new ByteArrayOutputStream();
ObjectOutputStream oos = new ObjectOutputStream(baos);

oos.writeObject(fileInfoObject);
oos.close();

byte[] header = encodeInteger(baos.size());

out.write(header, 0, 4);
baos.writeTo(out);

// write the file to out just as your question shows

On the receiving side:
    ......
    InputStream in = socket.getInputStream();
// read the int
byte[] header = new byte[4];

in.read(header, 0, 4);

int size = decodeInteger(header);

// read the object
byte[] objectbuf = new byte[size];

int count;

while((count += in.read(objectbuf)) < size); // not sure if this works...

ObjectInputStram ois = new ObjectInputStream(new ByteArrayInputStream(objectbuf));

Object fileInfoObject = ois.readObject();
ois.close();

// read the file
FileOutputStream fos = new FileOutputStream(new File("somefile"));

byte[] buffer = new byte[8192];
count = 0;
long left = castedFileInfoObject.fileSize;

// also not sure if this works, not tested.
int maxRead = buffer.length;

while (true) {
    count = in.read(buffer, 0, maxRead);

    left -= count;

    if (left < 8192) {
        maxRead = (int)left;
    }

    fos.write(buffer, 0, count);

    if (left == 0) {
        break;
    }
}

I haven't tested the sample code in my answer.. just to show the idea.

A: Class MyClass should implement the Serializable interface. Then, an object of this class can be written to an ObjectOutputStream and read back from ObjectInputStream using writeObject and readObject methods (See below).
On Client:
Socket socket = new Socket(url, port);
OutputStream os = socket.getOutputStream();
ObjectOutputStream oos = new ObjectOutputStream(os);
MyClass obj = new Myclass();
oos.writeObject(obj);
int count;
byte[] buffer = new byte[8192];
while ((count = in.read(buffer)) > 0) {
  out.write(buffer, 0, count);
}

On server:
ServerSocket sSocket = new ServerSocket(port);
Socket socket = sSocket.accept();
InputStream is = socket.getInputStream();
ObjectInputStream ois = new ObjectInputStream(is);
MyClass obj = (MyClass)ois.readObject();
byte arr[];
try {
  while(arr = (byte[])ois.readObject()) {
    //do something with arr
  }
} catch(java.io.EOFException) {
  // End of data
}

If you need to send more data after the file is finished, you need a way to figure out the number of bytes the file consists of. Then, you can send the number of bytes beforehand over the socket to the server. On the server, read only that many bytes of information for the file and then do the same for the rest of the data you are going to send. This strategy of pre-sending the file size is recommended and is mostly used while doing any data transfer. If you can do that, you don't have to rely on catching java.io.EOFException to detect end of data.

redpajama_set_name: RedPajamaStackExchange


text:
Controversy over grant takes further twist as payment method is ruled out
The Herald (p.3)
Scotland's arts funding body has insisted that a controversial £15,000 grant for an artist who will not leave Glasgow for a year must go to her personally.
Ellie Harrison, who is behind The Glasgow Effect which has provoked a storm on social media, had suggested the money would be paid to her employer, Duncan of Jordanstone College of Art & Design in Dundee.
In return, the lecturer would be allowed paid research leave to complete the project.
The college, part of the University of Dundee, also understood this to be the arrangement.
However, Creative Scotland now says this was not allowed under its Open Funding rules.
The university, which employs the artist on a part time basis, is now in discussions with the lecturer over how the situation can be resolved.
A statement from Creative Scotland said: "The £15,000 funding that was awarded to Ellie Harrison for the project, originally titled Think Global, Act Local!, through Creative Scotland's Open Project Fund was to support the artist in her work on this project and the development of her creative practice.
"The funds will not be paid to Duncan of Jordanstone College of Art & Design to cover the costs of her teaching post. This complies with our criteria for funding through the Open Project Funding route which states that it can be used to support 'the time to research, develop or create work or content including artist's bursaries to support practice development.'"
A spokesman for the university said: "Our agreement with Ms Harrison to free her time for the project has been predicated on costs being provided to cover her teaching time at the University.
"We are now in discussions with Ms Harrison in an effort to find a resolution."
The Glasgow Effect, is a well known phrase for discussing the poor health and low life expectancy of the most deprived areas of the city.
The project's Facebook page is illustrated with an image of chips, which people on social media said offended them.
However she stressed the project, which was initially called Think Global Act Local, is not primarily about poverty or deprivation in the city.
Ms Harrison said the bulk of her work in Glasgow will be setting up a "radical alternative" to existing funding systems, called the "Radical Renewable Art + Activism Fund."
The artist, who has lived in Glasgow since 2008, also published the full text of her application to Creative Scotland online.
She adds on her Facebook page: "The fact that this university (Duncan of Jordanstone), like most others in the UK, now requires its lecturing staff to be fundraisers and is willing to pay them to be absent from teaching as a result, should be the focus of this debate."
Phil Miller
The Glasgow Effect
Day-to-Day Data + Confessions Books £20.00
Radical Renewable Art + Activism Fund Sticker £3.00

redpajama_set_name: RedPajamaCommonCrawl


Score your energy now with our FREE ENERGY TEST. You can re-take the energy test as often as you like. Each time you complete the test, you will have access to your previous two results on line, this will allow you to track your progress over time.
It takes just 10 minutes to complete and gives you a score out of 100% for the 7 areas shown in the example below.


text:
Facts and figures from the 2022 season
Of the five X-Trials completed during this year, Toni Bou won four of them and Jaime Busto claimed one. Regular rivals Bou and Adam Raga were the only men to make the podium at every Round. No less than four other riders reached the rostrum during the campaign: Jaime Busto (twice), Matteo Grattarola (twice), Gabriel Marcelli (once) and Toby Martyn (once).
With regards to manufacturers, Montesa and TRRS each recorded six podium results, Beta finished with two and Vertigo one.
Of the 10 bonus points that were available for winning the opening two Rounds of each night, Toni Bou dropped just one, to Toby Martyn.
The newly proclaimed 16-times World Champion was the only rider who completed any course clean, managing each of the opening two runs at X-Trial Andorra la Vella without a penalty. At X-Trial Nice, Bou dropped just a single mark in each of his opening two rides, Grattarola managed the same in the first Round of the night.
The closest X-Trials of the season were X-Trial Chalon Chalon-sur-Saône (won by Bou 7 marks to 8) and Andorra la Vella (Busto victorious by 4 marks to 5 over Bou).
Toni Bou's four victories this season move him on to a career total of 73. He is followed in the all-time rankings by Adam Raga (38), Dougie Lampkin (36), Marc Colomer (33) and Albert Cabestany (18).
Adam Raga has now been on the rostrum in 43 consecutive X-Trials, in a run stretching back to 2014 that leaves him on 122 career podiums. Albert Cabestany (90), Toni Bou (87), Dougie Lampkin (80) and Colomer (76) are the riders that trail him.
MOTS STEP 5 CLEARANCE SALE!
MOTS Helmet Sale


Numerical approximation of the long time behavior of a stochastic di.erential equation (SDE) is considered. Error estimates for time-averaging estimators are obtained and then used to show that the stationary behavior of the numerical method converges to that of the SDE. The error analysis is based on using an associated Poisson equation for the underlying SDE. The main advantages of this approach are its simplicity and universality. It works equally well for a range of explicit and implicit schemes, including those with simple simulation of random variables, and for hypoelliptic SDEs. To simplify the exposition, we consider only the case where the state space of the SDE is a torus, and we study only smooth test functions. However, we anticipate that the approach can be applied more widely. An analogy between our approach and Stein's method is indicated. Some practical implications of the results are discussed. Copyright © by SIAM. Unauthorized reproduction of this article is prohibited.


text:
Q: Postgresql: date format and local language output I have two problem with postgresql.
The first one is I have to convert date in specific format like: friday 04 november 2016
SELECT to_char(tstamp, 'Day DD month YYYY') FROM ...

that's the result: https://i.stack.imgur.com/RjNnm.png
at first look the tstamp table disappeared and there're more space in the string:
friday....04.November..2016

*Hex encoding
the second one is that i have to convert it in a language format, in italian for example: "Venerdì 04 Novembre 2016".
Thank's for help

A: About first question: additional spaces are because month and Day patterns are:

blank-padded to 9 chars

https://www.postgresql.org/docs/9.6/static/functions-formatting.html
So, if you want to remove this spaces, you can try something like this:
 select trim(to_char(localtimestamp(0), 'Day'))||to_char(localtimestamp(0), ' DD ')||trim(to_char(localtimestamp(0), 'month'))||to_char(localtimestamp(0), ' YYYY')

--
About italian language, may be there is another ways too, but this should also work. You can hard coded italian month and day names and "translate" they using case expression, something like this:
select
    case
        when trim(to_char(tstamp, 'Day')) = 'Monday' then 'Monday_in_italian'
        when trim(to_char(tstamp, 'Day')) = 'Tuesday' then 'Tuesday_in_italian'
        when trim(to_char(tstamp, 'Day')) = 'Wednesday' then 'Wednesday_in_italian'
        -- another days here
    end||
    to_char(tstamp, ' DD ')||
    case
        when trim(to_char(tstamp, 'month')) = 'january' then 'January_in_italian'
        when trim(to_char(tstamp, 'month')) = 'february' then 'February_in_italian'
        -- another months here
    end||
    to_char(tstamp, ' YYYY')
    as tstamp
    from your_table

Note, that you should put all 7 day and all  12 month names in case expressions, if you want work this correctly for anytime.
Or even better, in case statements, you can use D pattern for determine day and MM pattern for month. If you want see available patterns list, you can follow link, I've posted above.

A: Oto's answer is all good, but with excessive coding. If your OS does not support Italian localization (locale -a), go with it. But if it does, you can format your time like here:
t=# set lc_time to 'it_IT.utf8';
SET
Time: 0.295 ms
t=# select to_char(now(), 'TMDay, DD TMMonth YYYY');
         to_char
-------------------------
 Giovedì, 11 Maggio 2017
(1 row)

Time: 3.705 ms

Formats anf TM prefix explanation can be found in docs


text:
The story appears on
Page C6
GET this page in PDF
Home » Feature » Art and Culture
City art expands to new horizons
By Wang Jie | August 20, 2009, Thursday | Print Edition
IT has taken Song Yunqiang 14 years to squeeze his J Gallery into a 100-square-meter area in Jin Jiang Hotel Shanghai to "attract more potential buyers."
"But the limited space really hindered the further development of the gallery," says Song, the gallery owner.
So J Gallery moved to a new and bigger space on Tianlin Road in Xuhui District in a creative industry center early this month.
The 2,000-square-meter new venue, almost 20 times bigger than its old place, seems to "free" everything - from the warehouse to the exhibition space and art styles.
"Different from the original realistic art style, we are now focusing more on abstract and expressionism," Song says. "Because of the abundant space here, we are now starting to collect artworks. Soon we will have our own collection."
Nowadays it is rare to find a gallery inside or near a hotel in downtown Shanghai, although it used to be a common sight.
The reason is that some gallery owners have realized that the limited space can no longer fulfill their big dreams in art.
It used to be a smart move to first open a small gallery in a hotel or in its neighborhood about a decade ago. At that time, there were not many local buyers.
Some five-star hotels became the first choice because of their special location. There is opportunity for both: The gallery needs potential Western buyers and the hotel wants to improve its "artistic status."
Like J Gallery, ShanghART and Yibo galleries have also adopted the same practice in recent years.
In 1999, ShanghART moved out from the Portman Ritz-Carlton hotel because "the space was too limited." Then it nestled down in a 100-square-meter narrow space adjacent to Park 97 in Fuxing Park.
However, it didn't last long.
In 2005, ShanghART joined M50, the city's first and most famous art hub which houses a cluster of galleries, artist studios and design workshops.
"Of course, it has pros and cons," says Helen Zhu, a staff member at ShanghART.
"We now have a total of 1,000 square meters, perfect for exhibitions and storage."
Then the "crazy" ideas from the artists are able to come true.
For example, Xu Zhen, one of the most daring and pioneering contemporary artists in China, will build a 6-meter-by-8-meter swimming pool filled with glue for his solo show next month at ShanghART.
"Just imagine, this would be totally impossible to implement at our old site. Now, it's no problem," Zhu says. "But of course, transport is not so convenient."
ShanghART has opened another new venue at 796 Huaihai Road, a luxury complex with Vacheron Constantin and Alfred Dunhill.
"Leaving our location and expanding space in other areas in the city reveals the maturity and confidence of a gallery," says Chen Yan, owner of Yibo Gallery. "Actually the prosperity of the art scene is in dramatic contrast to that a decade ago."
Yibo Gallery used to be in a two-story building opposite the Jin Mao Tower in Pudong, a location that was envied by many of his peers.
"We had no choice, because of the city's reconstruction plan," says Chen. "What a perfect location it used to be."
Last year, Chen left the 300-square-meter space where she had stayed for 10 years and headed to northeastern Shanghai's Yangpu District.
"Of course, we now have bigger space, about 1,500 square meters in total," Chen says. "Actually it is not as far as I expected, but this is a matter of the psychological distance."
Chen reveals that the business has not been affected by their move.
"Normally a gallery has a certain number of fixed collectors who have trust in the gallery," Chen says. "The only difference is that fewer visitors come to our new place. When we were opposite the Jin Mao Tower, every day artists, collectors and our friends would frequent the gallery for a drink or chat for a whole afternoon. So we feel a bit lonely here."
But Chen is quick to add: "Today, geographic advantage is not that important for a mature gallery. What you sell is whatis important."


Douglass was playing for famous amateur club, Crook Town, when he was signed by Sunderland, then in the First Division. That was in March 1952, but he was unable to break into the first team at Roker Park.
Moving south to Exeter City in June 1953, he was described as being well-built and several clubs had been interested in signing him.
However, it proved to be a good move to the Grecians as he made his debut in an opening day of the season win over Leyton Orient.
In his first season with the club, Douglass made 22 league appearances, but in 1954-55 he made the left-back slot his own with 44 league outings.
He, perhaps surprisingly, left St James' Park in the summer of 1955 after turning down an offer from City, and by July 1955 he was working for a firm of outfitters in Croydon.
After a year out of the game and turning down offers from both Sittingbourne and Tonbridge, he signed for Peterborough United in June 1956.
However, in November 1957, he announced his retirement from playing as it was interfering too much with his day time job.
He was back in football in March 1958 when he became manager of Corinthian Leaguers, Dorking. Douglass died in 1987.


text:
namespace Machete.Internals.Algorithms
{
    using System.Collections.Generic;
    using System.Linq;

    class TopologicalSort<T, TNode>
        where TNode : Node<T>, TopologicalSortNodeProperties
    {
        readonly AdjacencyList<T, TNode> _list;
        readonly IList<TNode> _results;
        readonly IEnumerable<TNode> _sourceNodes;

        public TopologicalSort(AdjacencyList<T, TNode> list)
        {
            _list = list;
            _results = new List<TNode>();
            _sourceNodes = _list.SourceNodes;

            Sort();
        }

        public TopologicalSort(AdjacencyList<T, TNode> list, T source)
        {
            _list = list;
            _results = new List<TNode>();

            var sourceNode = list.GetNode(source);
            _sourceNodes = Enumerable.Repeat(sourceNode, 1);

            Sort();
        }

        public IEnumerable<TNode> Result => _results;

        void Sort()
        {
            foreach (var node in _sourceNodes)
                if (!node.Visited)
                    Sort(node);
        }

        void Sort(TNode node)
        {
            node.Visited = true;
            foreach (var edge in _list.GetEdges(node))
                if (!edge.Target.Visited)
                    Sort(edge.Target);

            _results.Add(node);
        }
    }
}

redpajama_set_name: RedPajamaGithub


text:
package org.jboss.weld.tests.beanManager.bootstrap;

import static org.junit.Assert.assertTrue;

import javax.enterprise.inject.spi.Extension;
import javax.inject.Inject;

import org.jboss.arquillian.container.test.api.Deployment;
import org.jboss.arquillian.junit.Arquillian;
import org.jboss.shrinkwrap.api.Archive;
import org.jboss.shrinkwrap.api.BeanArchive;
import org.jboss.shrinkwrap.api.ShrinkWrap;
import org.jboss.weld.test.util.Utils;
import org.junit.Test;
import org.junit.runner.RunWith;

/**
 * Testcase for WELD-1729
 *
 * @author Antonin Stefanutti
 *
 */
@RunWith(Arquillian.class)
public class GetBeansExtensionTest {

    @Deployment
    public static Archive<?> deployment() {
        return ShrinkWrap.create(BeanArchive.class, Utils.getDeploymentNameAsHash(GetBeansExtensionTest.class))
            // Test bean
            .addClasses(CdiExtensionBean.class, GetBeansExtension.class)
            // Test extension
            .addAsServiceProvider(Extension.class, GetBeansExtension.class);
    }

    @Inject
    private GetBeansExtension extension;

    @Test
    public void hasBeanFromManager() {
        assertTrue(extension.hasBeanFromManager());
    }
}


Stun the crowd with this awesome pair of cat eye sunglasses from Idee that have class, style and amazing design all at the same time. They are must-have item to add in the collection of your accessories. They are crafted from metal material that make them long lasting. Also, they come with gradient and uv protected lens that lends them a fashionable look, while the lens with width of 59mm make them more appealing. They are sure to impart a classy and trendy look. Lens Width : 59mm.
An amazing pair of cat eyes with a classic appeal is a must-have item in your collection of eyewear and these one perfectly fits that space. You can combine them with your favourite outfit to make heads turn.


text:
Q: Mysterious: Elif and Counter Increment Bug Hi I am trying to run a for loop with an increment counter that switches into an elif statement.  The for loop is a way of building a string of syllables to synthesize with macintalk.  I would like to add a short silence every 20ms but I cant seem to get it to work, I've tried a bunch of debugging steps but none seem to work.  Can anyone spot the bug that prevents the elif from being accessed?

EDIT
Ok so I followed the suggestion below and used -eq instead = but I noticed that the counter only resets once and does not access the conditional statement a second time.  The revised code is posted below:
counter=0;
for k in $indx
do
    counter=$(($counter + 1));
    echo 'increment counter'
    echo $counter
    if [ $k -eq 0 ]
    then
        stream=$stream'@_'${syllarray[k]}
    elif [ $counter -eq 20 ]
    then
        echo Adding Silence after syllable: ${syllarray[k]}
        stream=$stream'_'${syllarray[k]}'[[ slnc 20 ]]'
        counter=0;
        echo 'reset counter'
        echo $counter
    else
        stream=$stream'_'${syllarray[k]}
    fi
done

Sample output:
Synthesize A Syllable Stream with Predetermined Lexicon, Word Order and Phonology
Parameters:
Voice --  Victoria
Rate (words/min) --  120
Pitch Modulation Interval --  0
Baseline pitch --  55
Directory Exists :)
Opening Syllable Transcription for Victoria
0
bIY
1
bUW
2
dAE
3
dOW
4
gOW
5
kUW
6
lAE
7
pAE
8
pIY
9
rOW
10
tIY
11
tUW
Counter Balanced Stimulus Order (Indexed by Syllables in Alphabetical Order)
11 2 9 8 4 6 0 5 10 11 2 9 8 4 6 1 3 7 8 4 6 0 5 10 11 2 9 1 3 7 0 5 10 8 4 6 1 3 7 0 5 10 8 4 6 11 2 9 0 5 10 1 3 7 8 4 6 11 2 9 1 3 7 11 2 9 0 5 10 1 3 7 8 4 6 0 5 10 11 2 9 8 4 6 1 3 7 0 5 10 8 4 6 11 2 9 0 5 10 8 4 6 11 2 9 0 5 10 1 3 7 8 4 6 1 3 7 0 5 10 11 2 9 1 3 7 8 4 6 0 5 10 1 3 7 11 2 9 1 3 7 11 2 9 1 3 7 0 5 10 8 4 6 1 3 7 0 5 10 11 2 9 0 5 10 11 2 9 8 4 6 11 2 9 1 3 7 8 4 6 0 5 10 1 3 7 11 2 9 8 4 6 0 5 10 8 4 6 1 3 7 11 2 9 0 5 10 1 3 7 8 4 6 11 2 9 8 4 6 1 3 7 11 2 9 0 5 10 8 4 6 11 2 9 0 5 10 8 4 6 11 2 9 1 3 7 0 5 10 1 3 7 8 4 6 0 5 10 1 3 7 0 5 10 11 2 9 1 3 7 11 2 9 8 4 6 0 5 10 11 2 9 8 4 6 1 3 7
Creating counterbalanced stimulus stream string with proper Macintalk formatting
increment counter
1
increment counter
2
increment counter
3
increment counter
4
increment counter
5
increment counter
6
increment counter
7
increment counter
8
increment counter
9
increment counter
10
increment counter
11
increment counter
12
increment counter
13
increment counter
14
increment counter
15
increment counter
16
increment counter
17
increment counter
18
increment counter
19
increment counter
20
Adding Silence after syllable: gOW
reset counter
0
increment counter
1
..
[truncated for clarity]
..
increment counter
268
Printing Stream to Screen
_tUW_dAE_rOW_pIY_gOW_lAE@_bIY_kUW_tIY_tUW_dAE_rOW_pIY_gOW_lAE_bUW_dOW_pAE_pIY_gOW[[ slnc 20 ]]_lAE@_bIY_kUW_tIY_tUW_dAE_rOW_bUW_dOW_pAE@_bIY_kUW_tIY_pIY_gOW_lAE_bUW_dOW_pAE@_bIY_kUW_tIY_pIY_gOW_lAE_tUW_dAE_rOW@_bIY_kUW_tIY_bUW_dOW_pAE_pIY_gOW_lAE_tUW_dAE_rOW_bUW_dOW_pAE_tUW_dAE_rOW@_bIY_kUW_tIY_bUW_dOW_pAE_pIY_gOW_lAE@_bIY_kUW_tIY_tUW_dAE_rOW_pIY_gOW_lAE_bUW_dOW_pAE@_bIY_kUW_tIY_pIY_gOW_lAE_tUW_dAE_rOW@_bIY_kUW_tIY_pIY_gOW_lAE_tUW_dAE_rOW@_bIY_kUW_tIY_bUW_dOW_pAE_pIY_gOW_lAE_bUW_dOW_pAE@_bIY_kUW_tIY_tUW_dAE_rOW_bUW_dOW_pAE_pIY_gOW_lAE@_bIY_kUW_tIY_bUW_dOW_pAE_tUW_dAE_rOW_bUW_dOW_pAE_tUW_dAE_rOW_bUW_dOW_pAE@_bIY_kUW_tIY_pIY_gOW_lAE_bUW_dOW_pAE@_bIY_kUW_tIY_tUW_dAE_rOW@_bIY_kUW_tIY_tUW_dAE_rOW_pIY_gOW_lAE_tUW_dAE_rOW_bUW_dOW_pAE_pIY_gOW_lAE@_bIY_kUW_tIY_bUW_dOW_pAE_tUW_dAE_rOW_pIY_gOW_lAE@_bIY_kUW_tIY_pIY_gOW_lAE_bUW_dOW_pAE_tUW_dAE_rOW@_bIY_kUW_tIY_bUW_dOW_pAE_pIY_gOW_lAE_tUW_dAE_rOW_pIY_gOW_lAE_bUW_dOW_pAE_tUW_dAE_rOW@_bIY_kUW_tIY_pIY_gOW_lAE_tUW_dAE_rOW@_bIY_kUW_tIY_pIY_gOW_lAE_tUW_dAE_rOW_bUW_dOW_pAE@_bIY_kUW_tIY_bUW_dOW_pAE_pIY_gOW_lAE@_bIY_kUW_tIY_bUW_dOW_pAE@_bIY_kUW_tIY_tUW_dAE_rOW_bUW_dOW_pAE_tUW_dAE_rOW_pIY_gOW_lAE@_bIY_kUW_tIY_tUW_dAE_rOW_pIY_gOW_lAE_bUW_dOW_pAE
Saving Synthesized Stream
Writing to:   ./synthesis/stream-Victoria/stream.flac


text:
Geoscientist employment: Western Australia at a glance
Click on the image for a high resolution PDF copy.
Funding for the WA Exploration Incentive Scheme (EIS) to be terminated
There has been considerable commentary over the past year that the WA Government would cease the funding for the Exploration Incentive Scheme (EIS).
The Association of Mining and Exploration Companies (AMEC) is concerned that termination of the EIS will have a catastrophic effect on the capacity of the GSWA to promote and develop the mineral potential of WA for the benefit of all West Australians. Fifty percent of the EIS funds are currently directed to the Co-funded Exploration Drilling program and 50% is used to generate pre-competitive information such as gravity data, aeromagnetic surveys, EM surveys, seismic surveys and specialized geological reports, maps and 3D geological plans.
Click here for further details of the proposal and what AIG members can do to support AMEC's efforts to preserve the EIS.
Migrating sand dunes pose potential risks to roads, homes and infrastructure
Dune having covered coastal access road just north of Green Head, Western Australia
A Western Australia Department of Mines and Petroleum (DMP) report has identified that migrating sand dunes, up to 4 km wide and 20 m high, pose potential threats to roads, homes and infrastructure in the State's Mid West.
While the report – Migration of Limesand Dunes in Western Australia and Their Impacts – has just been released, the information has already been presented to a number of State and Local Government agencies.
DMP Project Manager Mike Freeman, a key contributor to the report, has stressed that mobile dunes move very slowly over many years, but could cause serious problems if not monitored and kept in check.
DMP has presented the information and engaged with Local Government authorities in the Mid West, including the Shires of Gingin, Dandaragan, Coorow, Carnamah and Irwin, and the City of Greater Geraldton.
Find out more from the WA DMP web site.
Mid West WA Geotrail Proposal – have your say!
The Batavia Coast Maritime Heritage Association has initiated plans to establish a Mid West WA Geotrail and is seeking community input.
WA's Batavia coast, centred on Geraldton and Shark Bay
This area possesses a remarkable array of geological landscapes and rock and mineral formations. These include some of the oldest rocks at Jack Hills (dating back 4.4 billion years) to some of the youngest, with fossilised reef formations perched along our coast from just ~10 thousand years ago when sea levels were higher than at present. Banded iron-formations inland, ancient marine ammonite beds, glacial deposits, dinosaur bones, copper, lead and other ores, garnet dunes and stunning landscapes add even more to the geodiversity of the region and the reasons to establish a Geotrail.
How can you help? The Batavia Coast Maritime Heritage Association will convene a meeting of interested individuals and organisations in early 2017 to discuss this proposal and all interested parties are invited to attend. To find out more download this brochure.
Western Australia Field Guides
Earth Science Western Australia (ESWA) has commissioned John Bunting to write Geological Field Guides to Western Australia.
Two guides have been published:
A Field Guide to Perth and Surrounds
A Geological Field Guide to the Capes Region of Southwest WA
A third guide on the Western Australia Goldfields is currently in production.
A Field Guide to Perth and Surrounds is an A5, 110 page, spiral bound volume that covers six geologically significant locations in detail and in full colour. Featuring an overview of the geology of Perth, detailed descriptions at each locality and a comprehensive glossary, this guide is designed to make your geological excursions easy and enjoyable.
Free student booklets can be downloaded for each location from the field guides section of this website. Assistance with school excursions to any of these localities can also be arranged through contacting ESWA.
A Geological Field Guide to the Capes Region of Southwest WA is designed to assist readers in exploring the geology of the stunning Capes Region of Southwest Western Australia. With an overview of the remarkable geology of the region, as well as detailed walking tours for seven localities, it is a must for any enthusiast visiting the southwest.
It is a follow-up to the highly popular 'A Field Guide to Perth and Surrounds', which is reputed to be 'the ideal template for future field guides to follow and to be benchmarked agains' (Greg McNamara, The Australian Geologist, 2012). This guide is set to be a popular reference for teachers, field naturalists and tourists to the region
Copies of 'A Field Guide to Perth and Surrounds' and 'A Geological Field Guide to the Capes Region of Southwest WA' can be purchased via ESWA's online shop, powered by PayPal (you can pay via credit/debit card without having a PayPal account).
Don't forget that ESWA's textbook, Exploring Earth and Environmental Science, ia available to purchase on line from the ESWA website. ESWA also produces a range of resources for secondary teachers of Earth and environmental sciences.
For further information about ESWA publications contact Jo Watkins


The dark and glittering new novel from The Sunday Times Bestselling author Kate Hamer is as gripping asit is gorgeously written - the perfect second book fromthe author of The Girl in the Red Coat.
I wasn't lying. I'm a hunter for lost souls and I'm going to be with my real family.
And I'm not going to let Mick stop me.
Kate Hamer grew up in Pembrokeshire and has recently been awarded a Literature Wales bursary. Her bestselling novel The Girl in the Red Coat was a no 3. Sunday Times bestseller and shortlisted for the Costa First Book award. This is her second novel.


text:
FLCC to host talk on chocolate
Messenger Post Media messengerpost
Feb 21, 2019 at 12:07 PM Feb 21, 2019 at 12:07 PM
Discussions on "Cracking Open the Cocoa Bean" to center on ethical farming and business practices.
HOPEWELL — Finger Lakes Community College will host an insider's look at the chocolate industry.
"Cracking Open the Cocoa Bean" will be held at 5 p.m. Thursday, March 7, in Studio 14 at the college's main campus, 3325 Marvin Sands Drive.
The event includes talks by the owner of a cocoa bean company in Ghana and a Rochester chocolatier about ethical farming and business practices. The event is free and open to the public.
The leadership at Laughing Gull Chocolates on East Main Street in Rochester will open the program to discuss principles behind their business. For example, the business buys from Latin American farms that use sustainable farming practices and provide fair wages, and they train youths at their store to contribute to workforce development. Founder and chief chocolatier Lindsay Tarnoff started the business in Rhode Island in 2014 then moved it to Rochester where she was joined by Allison Zukoski, chief financial officer, and Karla Boyle, chief operating officer and a former FLCC student.
The second speaker is Steven Wallace, who founded the Omanhene Cocoa Bean Company in Ghana in 1991. Wallace first learned about cocoa farming in Ghana as a 16-year-old exchange student and began thinking about not only growing cocoa in Ghana, but making the end product — a chocolate bar — there as well.
The company makes the world's first single-origin chocolate bar, a process that provides higher wages to farmers and factory workers. Wallace wrote about his experience in "Obroni and the Chocolate Factory: An Unlikely Story of Globalization and Ghana's First Gourmet Chocolate Bar."
Kellie Gauvin of Pittsford, FLCC associate professor of biology, organized the event in cooperation with the owners of Laughing Gull Chocolates. Gauvin used chocolate in her first-year seminar class to teach about a wide range of biological topics, including biodiversity, microbial fermentation, and neurochemistry. In addition, the subject matter also allows her to introduce topics like social justice and ethical consumer choices.
"Students and the public will learn about entrepreneurship, ethical business practices, and how chocolate fits into the picture," Gauvin said. "They will also have an opportunity to ask questions of the business owners — and to taste the chocolates."
For more information about the talk, contact Gauvin at Kellie.Gauvin@flcc.edu or call FLCC Community Affairs at 585-785-1623. After the talk and time for questions from the audience, Laughing Gull will provide free chocolate tastings. Its products will also be available for sale.
Gates-Chili
Messenger Post Media on Twitter
Bob Chavez: @MPN_bchavez
Josh Williams: @mpnjosh
Julie Sherwood: @MPN_JSherwood
Jack Haley: @jackhaley42
Mike Murphy: @MPN_MikeMurphy
Jennifer Reed: @MPN_jreed
MPNnow ~ 73 Buffalo St., Canandaigua, NY 14424 ~ Privacy Policy ~ Terms Of Service


text:
Archive for Fredrick Knott
WAIT UNTIL DARK at the Geffen Playhouse
Photo by Michael Lamont
Suspense and suspension hallmark this sleek production. At the play's climax, on opening night, no breathing could be heard among the audience members. No one shifted in his seat, no one crinkled her program, no critic dared jot down a note. Suspense reigned. At the top of the play however, one must suspend disbelief, giving up all thoughts of "natural" or "expected" behavior. The earlier each viewer passes that tipping point, the more immersive this theatergoing experience will be for that viewer. Read more…
Terry Morgan - LAist
For whatever reason, suspense is not something theatre does very well. Perhaps it's the physical limitations of the stage space, but few plays attempt to be thrillers, and even fewer succeed at it. One of the notable exceptions to this truism is Frederick Knott's Wait Until Dark, a Broadway hit that became an even more famous film. Read more…
Les Spindle – Frontiers L.A.
The 1966 thriller Wait Until Dark by Fredrick Knott (Dial M for Murder), now being revisited in a world-premiere adaptation by Jeffrey Hatcher, relies on a timelessly intriguing damsel-in-distress formula. In a tense showdown between a Greenwich Village housewife and some thugs who invade her home, the key twist remains the heroine's blindness. This affliction proves both a weakness and a strength for her amid a battle of ingenuity and determination.
A hoary old thriller, Wait Until Dark still holds some scares for 21st century theatre audiences and can be seen at the Geffen Playhouse until Sunday, November 17.
The stage play by Frederick Knott—first performed in 1966—was famously filmed the following year and starred Audrey Hepburn. For this handsomely staged production, Matt Shakman directs Jeffrey Hatcher's world premiere adaptation. Read more…
Now running through November 17.
Tags : ArtsBeat LA, Dany Margolies, Fredrick Knott, FrontiersLA, Geffen Playhouse, Jeffrey Hatcher, Les Spindle, Pauline Adamek, Wait Until Dark


text:
Q: SELECTing data based on a specific time frame I'm using PostgreSQL. I have a table which stores data related to some orders. It has four to five columns, including:
cust_code char varying (20),
sugg_order integer,
ordered_qty integer,
date date

Now I want to find all the rows which occur within a specific time frame. Let us assume that this time frame starts on 1st of April every year and ends on 31st of March next year (like 2017-04-01 to 2018-03-31 and 2018-04-01 to 2019-03-31 and so on).
Below are the examples of the output which I want from the query:

*

*If I run this query on 2018-08-01 then I need all the data from 2018-04-01 to 2018-08-01.

*If I run this query on 2019-03-01 then I need all the data from
2018-04-01 to 2019-03-01.

*If I run this query on 2019-05-01 then I need all the data from 2019-04-01 to 2019-05-01
In other words, I need all data between today (the day I run the query) and the latest (most recent) 1st of April before today.
I need a query which will work for any year and I cannot get the start date of the time frame from outside.

A: In order to answer this, I did the following:
Created the table:
CREATE TABLE cust (cust_code VARCHAR(20), sugg_order integer, ordered_qty integer, ord_date date);

Created some sample data (note how it spans from early 2017 - before Apr 1st) to after today.
INSERT INTO cust VALUES ('cust_1', 45, 450, '2018-01-28');
INSERT INTO cust VALUES ('cust_1', 45, 350, '2018-02-28');
INSERT INTO cust VALUES ('cust_1', 45,  50, '2018-03-28');
INSERT INTO cust VALUES ('cust_1', 45, 451, '2018-04-01');
INSERT INTO cust VALUES ('cust_1', 45, 150, '2018-04-28');
INSERT INTO cust VALUES ('cust_1', 45,  87, '2018-05-28');
INSERT INTO cust VALUES ('cust_1', 45,  93, '2018-06-28');
INSERT INTO cust VALUES ('cust_1', 45,  56, '2018-07-28');
INSERT INTO cust VALUES ('cust_1', 45, 400, '2018-08-28');
INSERT INTO cust VALUES ('cust_1', 45, 234, '2017-01-28');
INSERT INTO cust VALUES ('cust_1', 45, 432, '2017-02-28');
INSERT INTO cust VALUES ('cust_1', 45, 657, '2017-03-28');
INSERT INTO cust VALUES ('cust_1', 45,  43, '2017-04-28');
INSERT INTO cust VALUES ('cust_1', 45,  32, '2017-05-28');
INSERT INTO cust VALUES ('cust_1', 45, 111, '2017-06-28');

WITH cte1 AS
(
  SELECT
    CASE
      WHEN DATE_PART('MONTH', NOW()) >= 4
        THEN TO_DATE(TO_CHAR(DATE_PART('YEAR', NOW())::INT,     '9999')     || '04' || '01', 'YYYYMMDD')
        ELSE TO_DATE(TO_CHAR(DATE_PART('YEAR', NOW())::INT - 1, '9999')  || '04' || '01', 'YYYYMMDD')
    END AS start_tax_year
)
SELECT * FROM cust, cte1
WHERE ord_date <= NOW() AND ord_date >= cte1.start_tax_year
ORDER BY ord_date

(There's a dbfiddle here)
I then ran 2 queries varying this line:
WHEN DATE_PART('MONTH', NOW()) >= 4 -- also used < 4
                                   -- to simulate a previous year.

Results with >= 4
cust_code sugg_order ord_qty    ord_date start_tax_year
   cust_1         45     450  2018-04-01     2018-04-01
   cust_1         45     150  2018-04-28     2018-04-01

Only two records - which is to be expected since we're only at the beginning of the tax year - just into May. A check shows that there are, in fact, only two records between today (May 10th) and Apr 1st.
Results with < 4
cust_code sugg_order ord_qty    ord_date start_tax_year
   cust_1         45      43  2017-04-28     2017-04-01
   cust_1         45      32  2017-05-28     2017-04-01
   cust_1         45     111  2017-06-28     2017-04-01
   cust_1         45     450  2018-01-28     2017-04-01
   cust_1         45     350  2018-02-28     2017-04-01
   cust_1         45      50  2018-03-28     2017-04-01
   cust_1         45     451  2018-04-01     2017-04-01
   cust_1         45     150  2018-04-28     2017-04-01

8 records - again to be expected, as the period between now and Apr 1st 2017 covers most of the data. If the date as sometime late in 2017, it would pick up the records between then and Apr 1st 2017.
The query is rather convoluted:
THEN TO_DATE(TO_CHAR(DATE_PART('YEAR', NOW())::INT, '9999')     || '04' || '01', 'YYYYMMDD')

The whole point of the CTE is to get April 1st of the correct tax year - i.e. the one we're in at the moment, even if we've gone into the next calendar year.
1) get DATE_PART from NOW() cast as an INT when we're beyond April first in the year where the query is being performed. This becomes
DATE_PART('YEAR', NOW())::INT - 1, '9999')

if the month part of the current year is < 4, it's before April, so you have to go back to April 1st of the previous year - which is where the -1 comes in.
2) once you've got the correct year for April 1st, then all the rest is the same. You then use TO_CHAR to transform this into a string and then using the double pipe characters (||) to concatenate the month (04) and day (01) to the correct year. Then use TO_DATE to convert the correct string (20180401) using the format string 'YYYYMMDD'.
3) then use the CTE to feed this value into the main query - obtain the desired records. Et voilà.

A: I think you want something like this:
with param (date, year) as
  ( select
        @date_param,
        extract(year from @date_param)
        - case when extract(month from @date_param) < 4 then 1 else 0 end
  )
select t.*
from table_name as t, param as p
where t.date >= make_date(p.year, 4, 1)
  and t.date <= p.date ;

A: The below query worked for my problem:
WITH get_year AS (SELECT
  CASE
  WHEN extract(MONTH FROM current_timestamp) < 4
  THEN extract(YEAR FROM  current_timestamp) - 1
  ELSE extract(YEAR FROM  current_timestamp)
  END)

  SELECT sugg_order, ordered_qty, date from table_1 t, get_year
  WHERE t.cust_id = $1
  AND t.date >= make_date(get_year.date_part::integer, 4, 1) and t.date <= current_timestamp
  ORDER BY t.date DESC


If no more serious bugs are reported, RC3 will become RTM.
Well, we went several weeks with no new serious bugs reported against WiX v3.9. In fact, we still haven't received a serious, newly-reported bug against WiX v3.9. Instead, we received confirmation on a fix for a long-standing bug discovered over a year ago and likely present all the way back to WiX v3.6. Frequent contributor Sean Hall discovered the key in some MSDN documentation and Mark Weaver confirmed the fix on the wix-devs mailing list.
So we took that fix and a couple of other very-low-risk fixes that were ready to be merged.
The result is WiX v3.9 RC4.
Because the fixes were took were minor and focused, we believe our Halloween release date is still feasible. We don't anticipate any other changes for WiX v3.9 but, as always, a serious-enough bug can change that. Download, test, and let us know!


Primarily, I am self-taught in both forms of art and am autistic.
I only say autistic because my biggest challenge is Live Social Contact. I have my own quirks, but don't we all.
I'm very serious about my artwork & I love to laugh when appropriate (who doesn't).
© 2019 LIDO RAPOSO. All Rights Reserved. Powered by HostBaby.


text:
Fassbender & Vikander Are Happy Together
Story from Pop Culture
Michael Fassbender & Alicia Vikander Are (Privately) Very Happy Together
Hunter Harris
Photo: Jonathan Hordle/REX.
Michael Fassbender really has a way with words, especially when it comes to his romance with Alicia Vikander. Proof: On Good Morning Britain, Fassbender was laughably tight-lipped about his relationship, concisely saying, "It's good that it happened," according to the Daily Mail. "It just happened," The X-Men actor said, as Daily Mail reports. "It's good that it happened. It is what it is." That's all. Fassbender's succinctness is a little on par with Jack "I'm sorry. I can't. Don't hate me." Berger from Sex and the City. Except that Fassbender's words aren't breaking up with anyone, they're just confirming the love we're all rooting for. A quick recap of the buzzy Light Between Oceans romance: Boy meets girl on a movie set. Boy and girl start dating on the down low. Boy and girl do a New York Times interview in which they're open to talking about the film, but insist on keeping their personal romance 100% private. Given the gossipy world of Hollywood, they've done a pretty good job of keeping their love low key. It seems like the couple wants to be excluded from our pop culture narrative. As Fassbender said, "It is what it is."
Michael Fassbender Alicia Vikander Happy Relationship
Pop Culture • Entertainment • Michael Fassbender
written by Hunter Harris
More from Pop Culture
Celebrities Don't Belong On TikTok — But Their Kids Do
The Jonas Brothers Are The Perfect Day Drinking Companions
The Jonas Brothers are living the good life. Not only are Kevin, Joe, and Nick each happily married to the loves of their lives, they're also releasing f
It Looks Like Even Courteney Cox Still Ships Jennifer Aniston and...
I normally try to stay away from the Jennifer Aniston/Brad Pitt hysteria out of respect for myself, who would not want anyone treating me and the boy I
Raven Gates Has One Simple Reason Not To Invite Rachel Lindsay To...
The feud between Raven Gates and Rachel Lindsay has deeply confused those who keep up with Bachelor Nation — mostly because neither party can give a spec
Sabrina Couple Confirms Their Relationship On TikTok, As G...
It sounds like Chilling Adventures Of Sabrina's many love triangles has affected the set. After rumors and cheeky Instagram posts, actors Ross Lynch
Brad Pitt Plans The Best Dates, According To Dax Shepard
After their sweet run-in at the SAG Awards (and Netflix after party) this Sunday, the world is once again searching for sparks between Jennifer Aniston and
Pamela Anderson Secretly Marries A Star Is Born Producer
Love can happen at any time — just ask Pamela Anderson. The Baywatch star recently married Jon Peters (the producer of critically-acclaimed film A Star I
Meet Archie's Godparents: Tiggy Pettifer & Mark Dyer
When Prince Harry and Meghan Markle celebrated the birth of their firstborn son Archie Harrison last May, the couple decided to forgo the usual protocol su
Prince Harry & Meghan Markle Have Officially Begun Living Their N...
Prince Harry and Meghan Markle's royal version of retirement has officially kicked off — and it sounds so idyllic. While Meghan left for Canada in
It's Back To Work For Prince Harry — His Royal Duties Aren&...
This weekend has answered a lot of lingering questions about Harry and Meghan Markle's royal departure. As we learned in a statement from Buckingham Pala
Brad Pitt & Jennifer Aniston's Reunion At The SAG Awards Has Cele...
If you watched Sunday night's Screen Actors Guild Awards and felt excited by the prospect of a Brad Pitt and Jennifer Aniston reunion, you weren't alon
Brad Pitt & Jennifer Aniston's Evening Together Did Not End...
Brad Pitt and Jennifer Aniston both had reason to celebrate at Sunday night's Screen Actors Guild Awards. While Pitt took home his first solo SAG Award f


Driven The Event - Complimentary Ticket!
Enter your information below to begin your application.
Apply now to get amplified!
Send in your application for complimentary admission to the event where your business can finally be seen!
This is the only event of it's kind where overnight a business owner can go from WHO? to WOW!
Driven The Event is the only business event where the attendees have the chance become the experts.
We created this application to uncover hidden gems, great ideas, and personal brands that deserve to be seen.
The application process is designed to weed out people who aren't willing to live big, dream big, and play big.
She started Driven Inc. from a spare room in a crowded apartment and in just a few years grew the company to serve thousands of clients, bring in millions of dollars each year, and craft high-profile, industry leading events. Suzanne lives with her family in Chapel Hill, North Carolina.
Suzanne Evans, owner and founder of Driven Inc., is the "tell-it-like-is", no-fluff boss of business building.
If you're tired of struggling on sales calls day after day. If you're ready to stop playing small and finally be seen.
If you feel like the world's best kept secret.


existence just 80 years ago, Israel is today widely known as one of the world's "start-up nations". From its number of entrepreneurs, to the level of venture capital investment and research and development (R&D), the small country of around 8.5 million people punches well above its weight when it comes to technology and innovation.
Together with co-founder Nir Gartzman, Carmeli launched theDOCK in July 2017 to help bridge the gap between the technology that exists in Israeli start-ups and the needs of the global maritime, ports and logistics sector.
In late October, the portfolio of start-ups had the chance to discuss their ideas with leading corporates such as Lloyds Register, MSC Cruises and Damen Shipyard at a "demo day" during the sixth annual Smart Mobility Summit in Tel-Aviv.