Inline.
2009/10/28 Hiren <[email protected]>:
>
> at the time of query upload,
I'm not sure what you mean here. My first interpretation of "query
upload" is "when query is sent to sql server", but your query string
does not contain a date value sent to the sql server.So I assume you
mean, "when data comes back from sql server".
> query is returning rows with date field along with time, I want to
> remove time part and display only date in dd/MM/YYYY format.
This does not necessarily have anything to do with HQL. You are
getting back Datetime instances.To format to the output string you
want in your user interface, use ToString(formatcode) on the Datetime
instance with the proper locale settings and format code.
ToString("dd/MM/yyyy") is a start if you don't want to be sensitive to
locale settings.
If the returned data is passing the boundary of some service interface
before reaching the user interface, and you have a business
requirement to only have date for this info, transform the Datetime
instances returned from NHibernate using zerotimeDatetime =
oldDatetime.Date in the service before returning them. The user
interface will use the same formatting code as above.
/Oskar
>
> On Oct 24, 7:29 am, Fabio Maulo <[email protected]> wrote:
>> only in query upload or even when you save the obj ?
>>
>> 2009/10/23 Hiren <[email protected]>
>>
>>
>>
>> > Dear Friends,
>> > We are developing application using VS2008, c#, SQL Server2000 and
>> > Nhibernate.
>>
>> > HQL query "select a.empname,a.joiningdate from entemp a"
>>
>> > here date of joining is coming along with time.
>> > I want to remove time part in query, could you pls help me.
>>
>> > thanks in advance
>> > hiren patel
>>
>> --
>> Fabio Maulo
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
